Send notifications on job STEP failures (trigger)

• spongemagnet

  SSCrazy

  Points: 2812

  More actions

  September 23, 2007 at 6:18 pm

  #181341

  Comments posted to this topic are about the item Send notifications on job STEP failures (trigger)

  
  -Ken

• Erin.

  SSCertifiable

  Points: 5237

  More actions

  September 29, 2009 at 8:42 am

  #1059508

  This trigger works perfectly on my one server, however I created it on a second server and for some reason I don't receive the email. Database Mail is setup and I made the change to exec msdb.dbo.sp_send_dbmail. Of course my error message is Error: 50000 Severity: 16 State: 10. Has anyone had this problem? I'm not sure where to check to get an understanding of what went wrong. There is nothing helpful in msdb.dbo.sysmail_allitems or msdb.dbo.sysmail_event_log.

  Thanks for you help.

  Erin