Provide a chance to fail a job if at least one step failed - by sqlhebo 72

Status : 


Sign in
to vote
ID 288793 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 7/24/2007 3:22:12 AM
Access Restriction Public


At the moment it is only possible to decide if a job should fail or succeed based on the outcome of the actual running step. It would be nice to define that a job should fail, if at least one step failed and to succeed if all steps succeeded. 

If I want to have such an behavior in the moment, I have to implement extra scripts which make everything much more complicate than it had to be, or I have to split it into multiple jobs.
Sign in to post a comment.
Posted by Amy [MSFT] on 8/3/2009 at 10:14 AM
Thank you for your feedback; unfortunately we won't be fixing this in the next release of SQL Server.


Amy Lewis
Posted by Gil [MSFT] on 10/31/2008 at 10:19 AM

We are considering it for the next release,


Posted by Microsoft on 7/30/2007 at 2:51 PM

Thanks for the suggestion, I've added it to the list for consideration post-SQL Server 2008.

-Richard Waymire
Program Manager, SQL Server Agent