Job Steps in SQL Server Agent [Resolved]

Posted by Nahesh under Sql Server on 11/30/2013 | Points: 10 | Views : 1229 | Status : [Member] | Replies : 1
How to go to last job step in the case of any other job steps failed ?
Example, how can i set to go step5 if any of previous steps failed in a job?


Posted by: Bandi on: 11/30/2013 [Member] [MVP] Platinum | Points: 50



1)Under job Steps page go to Advanced Page
2) On failure Action choose Go to Step5 option

repeat the above process for each step in the job (i.e. step1, step2, step3 and step4 )..

Mark This Response as Answer

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response