Notification from job in Sql Server 2005 doesn't work

• Linata

  Ten Centuries

  Points: 1370

  More actions

  April 9, 2008 at 9:54 am

  #121585

  Hi,

  I defined Dabase Mail in SqlSErver2005

  so EXEC msdb.dbo.sp_send_dbmail works fine.

  I want to receive also notification by email about completion of jobs.

  What must i define for it.

  Thanks in advance

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736504

  More actions

  April 9, 2008 at 10:04 am

  #800514

  Look in the SQLAgent section of BOL. You can add an alert for completion or failure of jobs.