emailling the log, not just the event?

• PompeyTID

  SSC Veteran

  Points: 269

  More actions

  January 10, 2007 at 11:34 pm

  #62791

  Hi there,

  This may appear a noddy question to some, so apologies in advance.

  I would like to know how to receive the output of a job that's been run, not just an email notification that it has run.

  Basically I'm running EXEC master..xp_fixeddrives as a scheduled job and would like the output of said command with the email I receive.

  Thanks in advance

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 11, 2007 at 1:29 am

  #682624

  depends how you're handling the email. putting the data into a temp table and placing the results via xp_sendmail is one method.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  January 11, 2007 at 4:17 pm

  #682799

  master.dbo.xp_sendmail @recipients='email@xyz.com',@query ='EXEC master..xp_fixeddrives'

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  January 12, 2007 at 12:08 am

  #682821

  you can store the output of the jobs as nad when run to a text file. then use the @attachments parameter so attach the file in your mail msg.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com