March 15, 2006 at 10:19 am
If you have a schedule job that kicks off every two hours starting at 2AM, if the 2AM runs till 5AM because there was a lot for it to do. Will the schedule instance at 4AM kick off? I say no because the job is alread running. My co-worker says he thinks it will. We are running SQL Server 2000 and SP4.
Thank you,
Carol
March 15, 2006 at 10:23 am
Carol
Check out this recent thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=263625
It seems to suggest that you're right.
John
March 15, 2006 at 10:26 am
Carol,
You mean that 2 jobs scheduled to run -- one for every 2 hrs starting at 2AM running until 5 AM and the other at 4AM. If so, then the second job will kick off at the scheduled time.
Note Only one instance of the job can be run at a time. If you execute a job manually while it is running as scheduled, SQL Server Agent refuses the request.
Lucky
March 15, 2006 at 10:36 am
Thank you both. I meant if a job runs over the two hours would I have two instance of the same job running since they are scheduled two hour intervals. You let me know this will not be the case which I thought it wouldn't but was not sure. Sometimes, the job may run over the two hours and sometimes not. When it does, we did not want another instance to be running because this could really make a mess of things.
Thank you,
Carol
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply