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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-14 : 19:12:20
|
Larry writes "In SQLServer 6.5, the Alert Engine (sqlalrtr.exe) could be used to detect when SQL Server shut down or restarted. In 7.0, SQL Alerter is a thing of the past. I've tried setting alerts on event numbers 17148 or 17162, and on error 17055 with a search for the text '17162:', but to no avail. I think the problem is that SQL Agent is not running during the SQLServer restart, and SQL Agent does not go back and read the NT Application Log for these errors. Have you found a way to be alerted when SQL 7.0 restarts? This is especially helpful in SQL Clustering, where the virtual server is up, but it would be great to know that it failed over to the other node in the middle of the night!
TIA,
Larry" |
|
|
|
|
|
Alerts when SQL 7.0 Not Running?