August 27, 2008 at 6:44 am
I have a SQL 2005 job with 5 steps.
All the steps have been set up as follows:
On Success: Go To The Next
On Failure: Go To The Next
This cannot change - they MUST go to the next step in either case.
What I want is for the system to e-mail me when any of the 5 steps fail; telling me which step has failed. But I can't seem to get a solution for this.
Other forums just state the obvious: Creating an extra step (step 6) to mail me, and then changing each step to: On Failure Go To step 6. But this is not an option, as all 5 steps must execute, irrelevant of the previous steps state (failure or success).
Any ideas?
Thanks
August 27, 2008 at 6:52 am
Create an extra step between the steps to send e-mail notification.
On Failure: Go to the new next step which you just added
On Success: Go to the step next to the next step.
August 27, 2008 at 7:02 am
Intermediate steps are the way to go.
Step 1: Do Something; on Failure go to Step 2; on Success go to Step 3
Step 2: E-mail to report failure for Step 1; continue to Step 3
Step 3: Do Something; on Failure go to Step 4; on Success go to Step 5
Step 4: E-mail to report failure for Step 3; continue to Step 5
Step 5: Do Something ... and so on
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 27, 2008 at 7:12 am
Thanks! That's probably the best option. It's a bit of a mission to implement but it will do exactly what I need...
Thanks again.
August 27, 2008 at 10:25 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply