rbartram-847800 (8/28/2014)
I have a similar issue.. I want all my steps in a job to go to the next step even if the step fails but I want it to send an email saying that step failed and it went to the next step. I don't believe you can do that natively in SQL server so how can we without adding try/Catch to each step?
It's simple; after each step insert an extra step, except after the last original step add two new steps. Configure each original step to invoke the following step if it fails and to the next but one step if it doesn't. Each new step except the last one sends an email and goes to the next step. The last new step does nothing, just exits.
This probably isn't the right way to address this problem, but it will work.
Tom