How to attach Job Output File to a Job's Email?

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  August 29, 2008 at 8:56 am

  #197091

  Within a SQL Server Job, I created a Job Output File by going to Job Properties, Steps, Edit, Advance Tab and entering an Output File Name. Then under the Notification Tab I set up the Email Options. I would like to know if there is a way to get the Job to email me the attached Output File. (This job contains two sql commands to truncate and shrink the log file. This job does not use a Maintenance Plan.) We are running Microsoft SQL Server 2005 (SP2) on Windows 2003 Server R2.

  Thanks in advance, Kevin

• AtTheLake

  SSChasing Mays

  Points: 636

  More actions

  August 29, 2008 at 9:27 am

  #865099

  I've used xp_sendmail as the last step of the job to send attachments like that.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 2, 2008 at 3:39 pm

  #866253

  In SQL 2005, you'd use sp_send_dbmail and set the @file_attachments parameter to the name of the output file.

  Greg