question

Dear sir, Is there a way to zip the file first (what are the commands?) and then send the file using sp_send_dbmail? My step in a job is as below: EXEC msdb.dbo.sp_send_dbmail @ recipients=N'Elena.Iasonos@bankofcyprus.com', @body='Dear Recipient, Please find attached the Users Audit Logs Report. -- Sent from Batch Emailer Automated Process. *** Note that this is an automated process. This email has been sent from a non-monitored email account. Please do not reply. ', @subject ='Users Audit LOgs - Report File - TEST',@profile_name ='BatchEmailer',@file_attachments ='H:\AutoReporting\UsersAuditLogsReport.xls';