CODEWITHSUNDEEP
sql-serversql-server-agent
Sylvain Pauly
Sylvain Pauly

Reputation: 11

Re-run entire job sql server - not just a step

I'm working on SQL Server Agent and i have some troubles. I need to re-run a job when a step fail, I mean, the entire job - not just the step. Is it possible ?

Do you know the best way to do this ?

Thanks a lot.

Upvotes: 0

Views: 2297

Answers (1)

Chris The DBA
Chris The DBA

Reputation: 105

Under the job step properties click on "advanced", you can then restart the job on step 1. It also gives you the option to retry a number of times before aborting and ending.

Upvotes: 1

Related Questions