How do I configure the number of worker threads used by SqlServer 2005 Agent

Posted by Decker on Server Fault See other posts from Server Fault or by Decker
Published on 2010-03-09T16:35:47Z Indexed on 2010/03/18 14:11 UTC
Read the original article Hit count: 578

How can I increase the limit of worker threads from the default 10 for SQL Server 2005 SqlAgent? I have 9 jobs that run almost continuously and that leaves only one available thread for the rest of the scheduled jobs. Oftentimes, when no thread is available, I will see the jobs in "Waiting for worker thread" state. I'd like to increase the number to about 12 (which should do the trick for me). Any idea where this is set?

© Server Fault or respective owner

Related posts about sql-server

Related posts about sqlagent