开发者

What happens to Jobs scheduled when SQL Server Agent is stopped?

开发者 https://www.devze.com 2023-04-12 22:25 出处:网络
On our SQL Server theres a SQL Job which is ran every hour. On one particular hour it doesn\'t seem like the SQL Job was ran, and that was due to the SQL Ser开发者_运维知识库ver Agent being stopped du

On our SQL Server theres a SQL Job which is ran every hour. On one particular hour it doesn't seem like the SQL Job was ran, and that was due to the SQL Ser开发者_运维知识库ver Agent being stopped during a backup.

If SQL Server Agent has been stopped, are the jobs which are supposed to be ran during the time its stopped simply ignored, or ran later when SQL Server Agent is running again?


They are ignored.

You can set up a schedule to start automatically when SQL Server Agent starts if you want to do some custom logic here such as checking for missing runs (and you can assign multiple schedules to a job)

0

精彩评论

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

关注公众号