September 10, 2003 at 3:03 pm
I used to know the answer to this and forgot. If I run a job daily at 5:30 PM, and the previous invocation is still running when 5:30 rolls around the next day, does SQL Agent:
a. Skip this invocation.
b. Delay the invocation till the first job finishes.
c. Run today's job simultaneously with yesterday's.
I vote for a. Anyone know for sure? (BTW, this would make a good QOD).
Vince
September 10, 2003 at 3:38 pm
If SQLAgent's daily scheduling works the same as others (eg. hourly or every minute) then the answer's A. It will skip the invocation.
I can't see any reason why daily scheduling would differ from hourly, but the best way to confirm is to try it out.
Cheers,
- Mark
Cheers,
- Mark
September 10, 2003 at 5:03 pm
No it won't. It reports an instance is already running and won't run again.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply