|
montu
Yak Posting Veteran
60 Posts |
 Posted - 2008-01-14 : 19:21:57
|
| I was under the impression or i always got following entries in SQL Agent error log when server restart and there are some entries in sql error log as well which confirms that server restarted. but today when i was checking error log i saw same entreis in SQL agent error log but there were no entries in server error log. now i got really confused whether my server is restarted or not........... because if it is restarted then there must be some messages in server error log..... can some one please let me know when and why following messages appear in SQL Agent Error LogInformation,[171] There are 9 alert(s) in the alert cacheWarning,[425] delay_between_response attribute (10 sec) of alert (9) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (8) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (7) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (6) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (5) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (4) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (3) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (1) is less than poll interval for this alert (20 sec)Warning,[425] delay_between_response attribute (10 sec) of alert (2) is less than poll interval for this alert (20 sec)Information,[170] Populating alert cache...Information,[168] There are 3 job(s) [0 disabled] in the job cacheInformation,[297] SQLServer Message: 0<c/> SQLServerAgent Monitor started successfully. [SQLSTATE 01000]Information,[133] Support engine startedInformation,[167] Populating job cache...Information,[110] Starting SQLServerAgent Monitor using '' as the notification recipient...Information,[193] Alert engine started (using Eventlog Events)Information,[146] Request servicer engine startedWarning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effectInformation,[174] Job scheduler engine started (maximum worker threads: 800)Information,[129] SQLAgent$XYZ starting under Windows NT service controlError,[364] The Messenger service has not been started - NetSend notifications will not be sentInformation,[124] Subsystem 'ANALYSISCOMMAND' successfully loaded (maximum concurrency: 800)Information,[124] Subsystem 'ANALYSISQUERY' successfully loaded (maximum concurrency: 800)Information,[124] Subsystem 'QueueReader' successfully loaded (maximum concurrency: 800)Information,[124] Subsystem 'Merge' successfully loaded (maximum concurrency: 800)Information,[124] Subsystem 'Distribution' successfully loaded (maximum concurrency: 800)Information,[124] Subsystem 'LogReader' successfully loaded (maximum concurrency: 200)Information,[124] Subsystem 'Snapshot' successfully loaded (maximum concurrency: 800)Information,[124] Subsystem 'CmdExec' successfully loaded (maximum concurrency: 80)Information,[124] Subsystem 'ActiveScripting' successfully loaded (maximum concurrency: 80)Information,[124] Subsystem 'TSQL' successfully loaded (maximum concurrency: 160)Information,[432] There are 10 subsystems in the subsystems cacheInformation,[431] Populating subsystems cache...Information,[339] Local computer is ABC running Windows NT 5.2 (3790) Service Pack 1Information,[310] ** processor(s) and **** MB RAM detectedInformation,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is ServerNameInformation,[102] SQL Server ODBC driver version 9.00.2047Information,[101] SQL Server ABC version 9.00.2047 (0 connection limit)Information,[100] Microsoft SQLServerAgent version 9.00.2047.00 (x86 unicode retail build) : Process ID 8100Error,[298] SQLServer Error: 2812<c/> Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs) |
|
so confused need help regarding error logs and SQL