SQL Server agent job schedules [Resolved]

Posted by Nahesh under Sql Server on 11/30/2013 | Points: 10 | Views : 588 | Status : [Member] | Replies : 1
I have one job running every day 5 times. i have scheduled a job to be run for every 1 hours from 9AM to 2PM on daily basis..

Now how to set the following option?
Job should be quit from schedule if job gets success before 5 hours.
i.e. suppose job gets success at 10 AM it shouldn't reoccur the job for that day?


Posted by: Bandi on: 11/30/2013 [Member] [MVP] Platinum | Points: 50


i think you are asking for schedule of a job with 5 attempts and if it gets success in any of attempt it shouldn't try to run again in a day..

If this is your requirement you better to go ahead with the following process:
1) use this link to schedule a job
Here set the frequncy as Daily occurs at once options...
2) Go to the step to be attempt 5 times under your job steps
3) In the Advanced Page set the Retry Attempts 5 and retry interval as 60 mins

It will solve the problem

Mark This Response as Answer

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response