版本是SQL SERVER2008R2, SQL AGENT日志里的错误如下
Date 8/7/2014 8:39:24 AM
Log SQL Server Agent (Current - 8/7/2014 8:43:00 AM)
Message
[398] The job (Distribution clean up: distribution) has been queued because the maximum number of working threads (100) are already running. This job will be executed as soon as one of the working thread finishes execution.
我已经更新了表msdb.dbo.syssubsystems的max_worker_threads的值，连服务器都重启过了
但是显然并没有应用这个更改后的值，SQL AGENT依然使用的是100这个默认值。
哪位大侠遇到过，给帮忙看看怎么解决
多谢
------解决方案--------------------
请问SQL Job是在执行什么?
LZ又是修改了syssubsystems里哪个subsystem的max_worker_threads值?
------解决方案--------------------
你的job是干嘛的？