[130] SQLSERVERAGENT stopping because of Windows s

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 2008 Forums

SQL Server Administration (2008)

[130] SQLSERVERAGENT stopping because of Windows s

Author

Topic

rocksteer
Yak Posting Veteran

69 Posts

Posted - 2012-02-08 : 09:14:56

In SQL Server 2008 error log I am getting the [130] SQLSERVERAGENT error. Why?

Date,Source,Severity,Message
02/07/2012 11:04:38,,Information,[098] SQLServerAgent terminated (normally)
02/07/2012 11:04:38,,Error,[382] Logon to server '(local)' failed (DisableAgentXPs)
02/07/2012 11:04:38,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
02/07/2012 11:04:37,,Error,[382] Logon to server '(local)' failed (SaveAllSchedules)
02/07/2012 11:04:37,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
02/07/2012 11:04:36,,Information,[130] SQLSERVERAGENT stopping because of Windows shutdown...
02/07/2012 10:58:51,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
02/07/2012 10:58:51,,Warning,[260] Unable to start mail session (reason: No mail profile defined)
02/07/2012 10:58:51,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
02/07/2012 10:58:49,,Information,[432] There are 12 subsystems in the subsystems cache
02/07/2012 10:58:49,,Information,[339] Local computer is NCCGOSVR0258 running Windows NT 5.2 (3790) Service Pack 2
02/07/2012 10:58:49,,Information,[310] 2 processor(s) and 4096 MB RAM detected
02/07/2012 10:58:49,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
02/07/2012 10:58:49,,Information,[102] SQL Server ODBC driver version 10.00.1787
02/07/2012 10:58:49,,Information,[101] SQL Server NCCGOSVR0258 version 10.00.1787 (0 connection limit)
02/07/2012 10:58:49,,Information,[100] Microsoft SQLServerAgent version 10.0.1787.0 (x86 unicode retail build) : Process ID 3156
02/07/2012 10:58:05,,Information,[393] Waiting for SQL Server to recover databases...

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2012-02-08 : 13:17:28

That is a notification message that the agent process is stopping because Windows is being shutdown. It is normal to see this when the system is restarted.

rocksteer
Yak Posting Veteran

69 Posts

Posted - 2012-02-09 : 05:04:50

If server shutdown and restarted why don't I see the startup of each of the databases in the log?

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2012-02-09 : 13:41:01

You won't see any database startup messages in this log - since it is the agent log and not the sql server log.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources