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 |
|
steppinthrax
Starting Member
27 Posts |
 Posted - 2008-05-05 : 13:54:00
|
| We are running SQL Server 2000. We had an instance where the SQL Server Agent failed for some reason. We started the service back up. Unfortunatley all the jobs underneath the Agent didn't run for about 2 or three days. Most of these jobs are setup to send a notification if the job fails. Since the server agent fails no notification can be sent. Is there a way to setup notification so that it sends a message if the SQL Server Agent Fails????? |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-05 : 16:28:20
|
| There are third party applications that monitor services and will give an alert if a service fails.Or if you feel like writing something yourself you can call it from the services interface under Administrative tools on the server. double click on SQLSERVERAGENT and click on the recovery tab.An infinite universe is the ultimate cartesian product. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-05 : 22:14:33
|
| Server vendor usually has free server monitoring tool, like insight manager for HP. |
|
|
|
|
|
|
SQL Server Agent (notification if stopped or fail)