September 8, 2008 at 8:06 pm
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
September 18, 2008 at 2:09 am
Hi, see http://support.microsoft.com/kb/306457
We had the same problem with jobs stalling and the above solved the problem.
September 18, 2008 at 2:14 am
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
September 18, 2008 at 2:25 am
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