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

Active

Type:	Suggestion
ID:	288793
Opened:	7/24/2007 3:22:12 AM
Access Restriction:	Public

Workaround(s)

view

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 (expand)

English

Tools

Add a new entry in the drop down menu for the job step outcome, and give the opportunity to fail if one step of this job failed.

Improved User Interface

Improved Administration

0 attachments

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

Microsoft