Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Please help with re-occuring SQL Agent error.

Author  Topic 

surefooted
Posting Yak Master

188 Posts
Posted - 2010-10-18 : 16:02:45
Hi,

We have been continually getting this error in our SQL Agent error log. If re restart teh server, the error goes away for a while. As soon as we run a large job with SQL Agent, we have this problem. Please help if you can. Below is the SQL Server Agent error log. the problem started at 3:35PM.

Thanks in advanced.

Date,Source,Severity,Message
10/18/2010 15:39:00,,Error,[380] Unable to start JobManager thread for job [Job name 11]
10/18/2010 15:39:00,,Error,[380] Unable to start JobManager thread for job [Job name 12]
10/18/2010 15:39:00,,Error,[380] Unable to start JobManager thread for job [Job name 3]
10/18/2010 15:39:00,,Error,[380] Unable to start JobManager thread for job [Job name 9]
10/18/2010 15:39:00,,Error,[380] Unable to start JobManager thread for job [Job name 7]
10/18/2010 15:39:00,,Error,[380] Unable to start JobManager thread for job [Job name 2]
10/18/2010 15:39:00,,Error,[380] Unable to start JobManager thread for job [Job name 5]
10/18/2010 15:38:00,,Error,[380] Unable to start JobManager thread for job [Job name 6]
10/18/2010 15:38:00,,Error,[380] Unable to start JobManager thread for job [Job name 3]
10/18/2010 15:38:00,,Error,[380] Unable to start JobManager thread for job [Job name 2]
10/18/2010 15:38:00,,Error,[380] Unable to start JobManager thread for job [Job name 4]
10/18/2010 15:38:00,,Error,[380] Unable to start JobManager thread for job [Job name 5]
10/18/2010 15:37:00,,Error,[380] Unable to start JobManager thread for job [Job name 6]
10/18/2010 15:37:00,,Error,[380] Unable to start JobManager thread for job [Job name 3]
10/18/2010 15:37:00,,Error,[380] Unable to start JobManager thread for job [Job name 9]
10/18/2010 15:37:00,,Error,[380] Unable to start JobManager thread for job [Job name 2]
10/18/2010 15:37:00,,Error,[380] Unable to start JobManager thread for job [Job name 5]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 6]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 11]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 12]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 3]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 7]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 2]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 4]
10/18/2010 15:36:00,,Error,[380] Unable to start JobManager thread for job [Job name 5]
10/18/2010 15:35:00,,Error,[382] Logon to server 'SERVER1' failed (ConnAttemptCachableOp)
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_DBC failed [SQLSTATE IM005]
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 15:35:00,,Error,[252] Failed to retrieve operator 3 from the server
10/18/2010 15:35:00,,Error,[382] Logon to server 'SERVER1' failed (ConnGetOperator)
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_DBC failed [SQLSTATE IM005]
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 15:35:00,,Error,[252] Failed to retrieve operator 1 from the server
10/18/2010 15:35:00,,Error,[382] Logon to server 'SERVER1' failed (ConnGetOperator)
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_DBC failed [SQLSTATE IM005]
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 15:35:00,,Error,[382] Logon to server 'SERVER1' failed (ConnAttemptCachableOp)
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_DBC failed [SQLSTATE IM005]
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 15:35:00,,Error,[382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate)
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_DBC failed [SQLSTATE IM005]
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 15:35:00,,Error,[382] Logon to server 'SERVER1' failed (ConnAttemptCachableOp)
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_DBC failed [SQLSTATE IM005]
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 15:35:00,,Error,[382] Logon to server 'SERVER1' failed (ConnAttemptCachableOp)
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 15:35:00,,Error,[165] ODBC Error: 0<c/> Memory allocation failure [SQLSTATE HY001]
10/18/2010 12:25:10,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
10/18/2010 12:25:09,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
10/18/2010 12:25:09,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
10/18/2010 12:25:09,,Information,[432] There are 11 subsystems in the subsystems cache
10/18/2010 12:25:08,,Information,[339] Local computer is SERVER1 running Windows NT 5.2 (3790) Service Pack 2
10/18/2010 12:25:08,,Information,[310] 8 processor(s) and 4096 MB RAM detected
10/18/2010 12:25:08,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
10/18/2010 12:25:08,,Information,[102] SQL Server ODBC driver version 9.00.4035
10/18/2010 12:25:08,,Information,[101] SQL Server SERVER1 version 9.00.4035 (0 connection limit)
10/18/2010 12:25:08,,Information,[100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 3552
10/18/2010 12:24:54,,Information,[393] Waiting for SQL Server to recover databases...


-Jon
Should still be a "Starting Member" .

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-10-18 : 16:06:46
I haven't encountered this, but perhaps it's due to a bug. You should consider installing CU11 for SP3 in case a bug fix addresses this issue.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

surefooted
Posting Yak Master

188 Posts
Posted - 2010-10-20 : 14:21:20
Can't get approval to install CU11 right now.

In addition to these errors, the SQL Agent is using over 1.8GB of memory and is not allowing any other connections.

-Jon
Should still be a "Starting Member" .
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-10-20 : 14:31:50
You should open a case with Microsoft PSS then.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site