How to Detect Email Failure

• MJ-727860

  SSC Veteran

  Points: 202

  More actions

  June 3, 2008 at 9:03 pm

  #187605

  Hi. My stored procedure emails users from a list in a table. Is there a way to detect if the email delivery failed?

  Thanks!

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  June 3, 2008 at 9:07 pm

  #823967

  SELECT * FROM msdb.dbo.sysmail_allitems

  WHERE sent_status = 'failed'

• MJ-727860

  SSC Veteran

  Points: 202

  More actions

  June 4, 2008 at 7:18 am

  #824149

  Thank you! 🙂