how do you zip a file in a schedule job so you can open the zip file in a unix machine.
thanks
So far i can do it with winzip
declare @cmd varchar(500)
select @cmd = 'wzzip.exe -a d:\...\...\filename'
select @cmd = @cmd + '.zip d:\...\..\file you want to zip'
-- Execute the zip command
exec master..xp_cmdshell @cmd
go