Query

• Mvs2k11

  Ten Centuries

  Points: 1223

  More actions

  September 28, 2011 at 10:05 am

  #243798

  I would like to send single notification for all jobs giving their statuses.

  How do i create a custom logging procedure to log the execution status of jobs to a table. then query to show up the results of table as email content.

  Please help

• M&M

  SSC-Insane

  Points: 21700

  More actions

  September 28, 2011 at 10:41 pm

  #1388178

  Check this article.

  http://www.sqlservercentral.com/articles/Automating+SQL+Server+Health+Checks/68910/

  M&M