本文介绍了如何防止 Sql Server 作业同时运行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
我的 SQL 代理中有一些预定的作业:
I have some scheduled jobs in my SQL Agent:
Job1，每 2 分钟执行一次
Job2，每 10 分钟执行一次
Job3，每 15 分钟执行一次
如您所见，多个作业可以同时运行.当这些作业同时运行时，会导致 CPU 使用率达到 100%.
As you can see, multiple jobs can run simultaneously. When these jobs do run simultaneously, it is causing the CPU usage to go to 100%.
有解决办法吗?有没有办法控制并发运行的作业数量?注意:我需要这些作业在适当的时间内大约运行.
Is there a solution? Is there a way to control the number of jobs running concurrently? Note: I need these jobs to run approximately in their appropriate period.
推荐答案
通过 sp_getapplock
您要求用户控制并发，这通常是最好的方法.
You're asking for user-controlled concurrency and this is usually the best way.
This allows you to wait or abort if the lock is already held by another job. We use it in one or 2 places to stop multiple users forcing the same task to run overlapping. It works well.
这篇关于如何防止 Sql Server 作业同时运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
