May 13, 2009 at 10:53 am
We are scheduling a power outage to our building (all day), I have many jobs in the Sql Server job agent that run during the day (a Saturday). I want to know, when the server comes back online, will the jobs that had a start time that has passed because of the down time run when it's back up. I want to ensure they server doesn't get over loaded upon restart.
Thank you in advance for assistance.
May 13, 2009 at 11:13 am
Hi,
The answer is no. The jobs that had a start time that fits on the server downtime will not be executed upon the server start.
Cheers
Alejandro Pelc
May 13, 2009 at 11:15 am
Great, thank you.
January 11, 2010 at 9:23 am
I have a 2005 server that was down this morning. When we got it back up, the first thing it did was run the jobs whose normal run times had been missed due to server being down - AUTOMATICALLY. We did not kick the jobs off.
This was news to me and I'm trying to figure out where this behavior is documented and whether I can turn it off.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply