June 21, 2006 at 9:27 am
I have a 5 step job, all the steps run 1 stored proc.
the 3rd step has an inserts that can fail due to a FK relation.
on the first insert failure, it seems to stop the whole step. why ?
..doesn't happen when you run it via Q.A.
June 22, 2006 at 8:15 am
In sql agent, open job property-->steps tab-->the step 1-->advanced, try to change "on failure action" to "go to next step"
June 27, 2006 at 8:28 am
The only problem with going to the next step on failure is there is no indication that a failure occured. Some of my jobs I have inserted an addtional step between steps that sends an e-mail that a failure occurred. I then set the first step to skip over the message step on success and go to the next step on failure.
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply