SQL Server agent job schedules [Resolved]

Posted by Nahesh under Sql Server on 11/30/2013 | Points: 10 | Views : 1082 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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?

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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 http://technet.microsoft.com/en-us/library/ms191439.aspx 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 -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Nahesh, if this helps please login to Mark As Answer. \| Alert Moderator

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
http://technet.microsoft.com/en-us/library/ms191439.aspx
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
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Latest Posts