SQL Agent Problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Agent Problem

Hi, I am getting the following errors in my SQL Agent log and although the SQL Agent has not hung it will not execute jobs. Restarting it fixes the problem. SQL 2k Ent sp3
Win Server 2003 SQLAgent Log: 2005-02-27 18:38:58 – + [396] An idle CPU condition has not been defined – OnIdle job schedules will have no effect
2005-02-27 18:38:58 – + [408] SQL Server MSSQLSERVER is clustered – AutoRestart has been disabled
2005-03-02 13:20:01 – ! [380] Unable to start JobManager thread for job Monitor_eFX_Service
2005-03-02 13:20:02 – ! [380] Unable to start JobManager thread for job CRS_Import_Export
2005-03-02 13:20:03 – ! [380] Unable to start JobManager thread for job Transaction Log Backup Job for DB Maintenance Plan ‘CRS to Mirror’
2005-03-02 13:20:04 – ! [380] Unable to start JobManager thread for job Transaction Log Backup Job for DB Maintenance Plan ‘Credient to Mirror’
2005-03-02 13:20:05 – ! [380] Unable to start JobManager thread for job CRS_NearTimeRebuild
2005-03-02 13:20:06 – ! [380] Unable to start JobManager thread for job Transaction Log Backup Job for DB Maintenance Plan ‘eFX to Mirror’
2005-03-02 13:20:07 – ! [380] Unable to start JobManager thread for job Monitor_SQL Server Blocks
2005-03-02 13:23:45 – ! [298] SQLServer Error: 109, [SQLSTATE 08001]
2005-03-02 13:23:45 – ! [298] SQLServer Error: 109, ConnectionOpen (LoadNetlibs()). [SQLSTATE 01000]
2005-03-02 13:23:45 – ! [382] Logon to server ‘NABPRODSQL’ failed (ConnAttemptCachableOp)
2005-03-02 13:24:18 – ! [298] SQLServer Error: 109, [SQLSTATE 08001]
2005-03-02 13:24:18 – ! [298] SQLServer Error: 109, ConnectionOpen (LoadNetlibs()). [SQLSTATE 01000]
2005-03-02 13:24:18 – ! [382] Logon to server ‘NABPRODSQL’ failed (ConnAttemptCachableOp)
2005-03-02 13:24:51 – ! [298] SQLServer Error: 109, [SQLSTATE 08001]
2005-03-02 13:24:51 – ! [298] SQLServer Error: 109, ConnectionOpen (LoadNetlibs()). [SQLSTATE 01000]
2005-03-02 13:24:51 – ! [382] Logon to server ‘NABPRODSQL’ failed (ConnAttemptCachableOp)
2005-03-02 13:25:00 – ! [380] Unable to start JobManager thread for job Monitor_Pings
2005-03-02 13:25:01 – ! [380] Unable to start JobManager thread for job Monitor_eFX_Service
2005-03-02 13:25:02 – ! [380] Unable to start JobManager thread for job CRS_Import_Export
2005-03-02 13:25:23 – ! [298] SQLServer Error: 109, [SQLSTATE 08001]
2005-03-02 13:25:23 – ! [298] SQLServer Error: 109, ConnectionOpen (LoadNetlibs()). [SQLSTATE 01000]
2005-03-02 13:25:23 – ! [382] Logon to server ‘NABPRODSQL’ failed (ConnAttemptCachableOp) Event Viewer Log: SQL Server Scheduled Job ‘Monitor_SQL Server Blocks’ (0xA50984C6000209489F82F3D58E557D1B) – Status: Failed – Invoked on: 2005-03-02 13:37:39 – Message: The job failed. Unable to determine if the owner (NABCREPRODCredientSQL) of job Monitor_SQL Server Blocks has server access (reason: Unable to connect to server – check SQL Server and SQL Server Agent errorlogs). The SQLAgent is set to run as a domain Admin. But not as a local admin. It is also set to logon as a service.
Has anyone ever come accross this before. Thanks in advance. JD
try to change the Job owner.
For changing the job owner , right click on the job and click on agent properties.
I guess It may work .
I suspect this may be problem on the network with name resolution issue with WINS.
As it resolves the server nebios name and very ping works with the netbios name.
Verify that the servername is specified correctly. Try this test from the problem client. net view \SQLServerName If this returns error 53 Network Name Not found , then netbios name resolution is your problem. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya, Thanks for your suggestion. The instance is running in a clustered environment. I tried what you suggested and the following what was returned. Is this what you would expect? C:>net view \NABPRODSQL
Shared resources at \NABPRODSQL Share name Type Used as Comment ————————————
backup Disk W:
shared Disk
transaction Disk
The command completed successfully. Thanks
Jamie.
]]>