开发者

Sql Server Agent job running longer than interval between executions

开发者 https://www.devze.com 2023-04-05 19:38 出处:网络
I would like to know what happens if an agent job (with recurring interval) in MS SQL server runs long enough so that it overlaps recurring execution.

I would like to know what happens if an agent job (with recurring interval) in MS SQL server runs long enough so that it overlaps recurring execution.

According to my tests, paralleled execution does not happen, which i开发者_运维问答s good.

What I'm trying t find out is that will the next execution be ignored because the previous one is not finished yet, OR will it be queued?

By "queued" I mean executing the queued requests immediately after the previous completed discarding the schedule.

Thank you


It will not be queued, it will be skipped. Easy to test: Create a job with a WAITFOR DELAY '00:05:00';, schedule job for < 2 minutes from now, then start the job manually. It will run for 5 minutes, once.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号