Job Steps in SQL Server Agent [Resolved]

Posted by Nahesh under Sql Server on 11/30/2013 | Points: 10 | Views : 686 | 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?




Responses

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

Up
0
Down

Resolved

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
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Login to post response