Send notifications on job STEP failures (trigger)

By Kenneth Singer, 2013/05/23

Have you ever wanted to have SQL note a failure on a step, yet continue running the job. I found it to be annoying that you have to fail (and end) a job in order to send a message to an operator. I have processes that run at off times, I want to know when there are failures but I need the remainder of my steps to run, period. This trigger makes use of xp_sendmail to send emails to someone, as well as generate an error in SQL's error log. I welcome any comments, suggestions and criticisms.

mailto:ken.singer@sagepub.com

Total article views: 2057 | Views in the last 30 days: 9

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Send notifications on job STEP failures (trigger)

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: