April 4, 2011 at 4:11 am
What would happen if, say, I set Transaction Log backups to every minute and they overlapped? Would it result in a loop of some sort that never ends?
Regards
Steve
April 4, 2011 at 5:22 am
If you're talking about scheduling via SQL agent, there can only be one instance of a job running. If a job is still running when it's next start time arrives, SQL Agent won't start the job again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 4, 2011 at 6:36 am
Oh OK - so if an agent job is about to start it will be missed if the same job is still currently running.
thanks
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply