SQLAGENT job waiting on worker thread

  • Anyone can help me to extend the maximum work thread in sql agent in sql 2000, microsoft help not work, I already tested into my sql local. I edit into 20 but still after 10 job process, still waiting for worker thread.

    Anyone can help me?

    Thank

    Ayie

  • Hi, see http://support.microsoft.com/kb/306457

    We had the same problem with jobs stalling and the above solved the problem.

  • Hello,

    I already fixed that error, now if i schedule 1 job in one time scheduled, I receive this error

    "Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 28"

    Can you help me to fixed this error?

    Thanks

  • Hi,

    I have never seen this problem but a quick search on google revealed the following

    http://support.microsoft.com/?scid=kb;en-us;Q295378

    I hope it solves your problem.

Viewing 4 posts - 1 through 3 (of 3 total)

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