delete file
DECLARE @cmd VARCHAR(1000);
DECLARE @filePath VARCHAR(255) = 'C:\tt\tt.zip';
DECLARE @output TABLE (output VARCHAR(1000));
SET @cmd = 'del "' + @filePath + '"';
INSERT INTO @output
EXEC xp_cmdshell @cmd;
SELECT output
FROM @output;