August 21, 2013 at 11:24 pm
Dear all,
we have sql agent job,the job is schedule everyday @9.30 A.M and @5.30 P.M.
@9.30 scheduled job is failure means need to retry every 10 mins with 3 attempt.
I have question retry attempt job should affect current job schedule or not.
please explain the detail,if we give the retry timeout for job there is any problem?
please help on this.
August 22, 2013 at 6:52 am
I might suggest having a small control table for this job.
Set up the job schedule to run @ 9:30 and every 10 mins for as many retry intervals as you deem necessary. The job step will update the control table as to completion time and completion status when it runs. On each start interval, job step will check control table and will run the procedure again only if the last run status is non-existant or indicates a failure. If it sees success for the last run the job step just exits doing nothing.
The probability of survival is inversely proportional to the angle of arrival.
September 18, 2018 at 5:16 am
i want to clarify the below 2 scenarios
1. i have 3 steps SQL job. Each steps contains 3 packages. Suddenly the job has failed. Because of some Resource issue. Can i go with retry attempt in sql?
2. if i use retry attempt, 1 step succeeded with load some amount of data to target. But Step 2 has failed because of some resource problem. Sql job tries to rerun the job. Here my question is once again step 1 will rerun OR Step 2 only will rerun.
I want this solution ASAP. Very urgent
3. Will it rerun always, in case of failure in package?
Manik
You cannot get to the top by sitting on your bottom.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply