Re-execute SQL Server job in case of failure -
currently creating sql server job. requirement whenever job fails, needs run 1 more time. possible in sql server?
i'm not sure if best way it, can configure every single step of job re-run specific number of times after specific number of minutes (in case of network troubles, example). open step configuration in sql server management studio , set "retry attempts" , "retry interval (minutes)" according preferences.
of course, not work if want re-run whole job beginning , not retry infinitely.
Comments
Post a Comment