February 3, 2010 at 6:34 am
SQL Server 2008 SP1 on 64bit Windows Server 2003. I have about 50 jobs that are nothing more than a WMI event watcher task watching for a file and then importing the data into specific tables. The WMI task is set to only watch for 3 hours and then return failure.
Every morning when I check the status of the jobs there's always 3 or 4 jobs that are still executing even though the WMI task should have timed out hours ago. Has anyone seen anything similar to this?
February 3, 2010 at 11:07 am
I have experienced issues with a 64 Bit Server.
What task(s) are hanging and what processes do they use?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply