Post reply

Limit to Number of SQL Agent Jobs

  • July 24, 2009 at 10:28 am

    #203092

    Is there a limit to the number of jobs SQL Agent(2008 Enterprise Ed.) can run?

    We are trying to run cdc and replication on about 85 databases. At a certain point as we enable these we get jobs that go into "waiting for a worker thread" status.

    I've seen posts here and there that suggest increasing the max_worker_threads value for the T-SQL subsystem column in the msdb.dbo.syssubsystems table. Has anyone done this(to success :-D)? What other possible solutions are out there?

    And is there a limit to the number of jobs SQL Agent can kick off on startup? And what the workaround for that is, if there is a limit?

    Thanks!

  • February 25, 2010 at 1:24 pm

    #1125192

    I'm looking into this myself. in my case, the max_worker_threads has been set to 400 on our server in the syssubsystems table, but we're still getting an error saying we've reached the max of 100 and the jobs are waiting.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply