Database mail

• alan.nichol

  Old Hand

  Points: 359

  More actions

  December 23, 2008 at 5:02 am

  #204458

  Dear all

  I want to be able to send the result of any DBCC statement via Database Mail so I can collate the information at a more convenient time.

  There are a number of servers that I look after that would benefit from receiving this information on a regular basis without logging on to each one.

  I can set a job to activate the DBCC statment and e-mail me that fact that it has worked but I cant figure out how to e-mail the results.

  Any help would be very grateful

• Vee

  Hall of Fame

  Points: 3028

  More actions

  December 27, 2008 at 11:12 am

  #918054

  Divert the output of the dbcc job to a file and use the attach statement of the file while sending mail.