April 22, 2016 at 8:53 am
Is it possible to have a SQL Job retry a step, maybe a couple of times, after it fails? And let's say delay the retry for 30 minutes or so.
(I'm sorry to ask this question, but at least in the only database I see I have access to SQL Server Agent the best I can do is just execute a SQL job. So I can't experiment to find out for myself.)
Kindest Regards, Rod Connect with me on LinkedIn.
April 22, 2016 at 9:03 am
In job setting we have to give the retry Attempts(5) and Retry Interval (After 2 min or 30 min)
Got to job properties-->Select steps-->Edit the step-->Just below the on Success action you can see the Retry Attempts and Retry interval options.
April 22, 2016 at 9:04 am
Yes.
Under the job step properties, in the advanced section, there's a spot for Retry Attempts and Retry Interval which do exactly that.
Cheers!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply