December 3, 2010 at 3:56 am
SQLSERVERAGENT service on Local Computer started and then stopped. Some services stop automatically
In Sql server 2008
December 3, 2010 at 4:30 am
Please post the SQL Server Agent Logs. The log files are named SQLAGENT.* where an extension of "out" is for the currently running service and previous files have a numeric digit extension. An example of the log contents are:
2010-10-22 03:14:36 - ? [393] Waiting for SQL Server to recover databases...
2010-10-22 03:15:14 - ? [100] Microsoft SQLServerAgent version 10.0.2775.0 ((Unknown) unicode retail build) : Process ID 1960
2010-10-22 03:15:14 - ? [101] SQL Server CCCMSRSQL18\DBATEST version 10.00.2775 (0 connection limit)
2010-10-22 03:15:14 - ? [102] SQL Server ODBC driver version 10.00.2775
2010-10-22 03:15:14 - ? [103] NetLib being used by driver is DBMSSOCN.DLL; Local host server is CCCMSRSQL18\DBATEST
2010-10-22 03:15:14 - ? [310] 2 processor(s) and 3839 MB RAM detected
2010-10-22 03:15:14 - ? [339] Local computer is CCCMSRSQL18 running Windows NT 6.0 (6001) Service Pack 1
2010-10-22 03:15:18 - ? [432] There are 12 subsystems in the subsystems cache
2010-10-22 03:15:21 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2010-10-22 03:15:21 - ? [129] SQLAgent$DBATEST starting under Windows NT service control
2010-11-19 02:53:42 - ? [130] SQLAgent$DBATEST stopping because of Windows shutdown...
2010-11-19 02:53:43 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2010-11-19 02:53:43 - ! [382] Logon to server 'CCCMSRSQL18\DBATEST' failed (SaveAllSchedules)
2010-11-19 02:53:45 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2010-11-19 02:53:45 - ! [382] Logon to server 'CCCMSRSQL18\DBATEST' failed (DisableAgentXPs)
2010-11-19 02:53:45 - ? [098] SQLServerAgent terminated (normally)
SQL = Scarcely Qualifies as a Language
December 3, 2010 at 5:07 am
SQLAgent service stoped automatically.
Can you post what is SP level is updated on you SQL 2008 box?
I have also same problem in SQL 2000 with SP3 due to dll files courrpted, Problem resolved after updated SP4.
rgds
ananda
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply