Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dholland
Starting Member
11 Posts |
 Posted - 2008-04-18 : 19:29:49
|
| Good day,I have a Job that runs every half an hour, and has about 30 steps. If a step fails it moves on to the next step (the steps are not dependant on one another)... However I would like to receive notification if that occurs. I have SQL 2005, with database mail enabled and set up (works fine for other jobs)... The question is how do I get it to send me an email if a single step fails, however the job on a whole succeeds?Do I need to set up a step between each job?Step 1 An actual step, on failure: step 2 On success Step3Step 2 A step that emails the failure of step 1, then goes to step 3Step 3 An actual stepetc etc... Or is there a better way? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 17:36:24
|
| You need add that logical and send mail code in job steps. |
 |
|
|
|
|
|
Failure notifications for individual steps?