Home Dashboard Directory Help
Search

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


Status: 

Active


0
1
Sign in
to vote
Type: Suggestion
ID: 288793
Opened: 7/24/2007 3:22:12 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft 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.

Thanks,

Amy Lewis
Posted by Microsoft on 10/31/2008 at 10:19 AM
Hi,

We are considering it for the next release,

Thanks,

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

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

-Richard Waymire
Program Manager, SQL Server Agent
Sign in to post a workaround.