开发者

Sql Job running for 30 minutes then report successful

开发者 https://www.devze.com 2023-04-07 16:17 出处:网络
We have a job that runs every night and rebuild the indexes on a customer database, however after instal开发者_StackOverflow中文版ling the job, it runs successfully every night according to the histor

We have a job that runs every night and rebuild the indexes on a customer database, however after instal开发者_StackOverflow中文版ling the job, it runs successfully every night according to the history and finishes in around 30 minutes every night, however we found that the indexes that it should fix, are not actually fixed and still fragmented above the allowed level.

Is there anything that would stop a job from running more then 30 minutes? It currently doesn't have an end date on it.


The end date is about when a schedule (for determining when to start the job) should cease to be valid. There is a Shutdown Timeout setting in Sql Server Agent Properties, but that defaults to 15 seconds, and is about completing shutdown, rather than total execution time.

So...

Have you run the script manually?

How long does it take to complete?

Does it complete successfully according to your standards?

Related:

  • SQL Agent: Set a Max Execution Time
0

精彩评论

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