How to send job failure email with job details?

Question

How to send job failure email with job details?

WayneS

SSC Guru

Points: 95460
More actions
August 14, 2008 at 7:31 am

#125726

I have two steps in a job:
1. do the work.
2. if 1 fails, send a failure email (via execute master.dbo.xp_sendmail).
In step 2, how do I include the details of why step 1 failed in the email?
Thanks!
Wayne
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

On the advanced tab, you can specify logging. You can also choose to have step 1 end the job if it succeeds. If it fails have it go to step 2 and then grab the log file from step one.