Jim

If you have xp_cmdshell enabled, you can use it to run the command line for your zip utility. Otherwise, you could consider using SSIS to do the same. Another alternative is to run it from a Windows scheduled task, bypassing SQL Server altogether.

John