asked
sql server job should rerun automatically because of deadlock reason.
I want sql server job should run max three times if job failed because of deadlock reason. Is there any conditional setting for retry option? what is the best approach to do the same? Thanks, Gopal
Hi Gopal, I'm prepared to be corrected, however, I don't know of any way through the GUI to set a re-run conditionally on a deadlock error. It just re-runs on any error - is that a bad thing for you? You could implement a custom retry solution. I.e create a SPROC and put it in another agent job, it could then be set to run after the first job has finished. The sproc could check for run failures and you specify exactly what error your looking for, if it finds that error it can call the job to re-run. It's an option - however - I'd just have my jobs set to re-try all the the time and alert me if there is an issue. However, an even better solution is to work out why that job keeps deadlocking and try to fix that issue! Have a good day!
18 People are following this question.
