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.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-12-14 : 21:16:33
|
| I got a foglight alert that sql agent is down on one sql 2000 serverBut now sql services are up and running fine.How do i investigate that why sql agent was downPlease advice? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-14 : 23:24:02
|
| Take look at sql agent error log, sql server log and windows event log. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-15 : 02:18:38
|
| I found below errorseventlogThe description for Evenet ID (102) in source (sql server Agent) cannot be found .The local computer may not have thte necessary registry information or message DLL files to display messages from a remote computer.You may be able to use the /AUXSOURCE=flag to retrieve this description ; see help and support for details. The following information is part of the event.sql agent log(364) The messenger service has not been started-Netsend notifications will not be sent |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 02:32:50
|
| None of them tell anything useful. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-15 : 02:35:06
|
| Now SQL Services are up runningSo can I close the ticket saying that nothing found in error logs? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 03:10:08
|
| It's your call. |
|
|
|
|
|
|
SQL agent down