SQL Server Alerts...

[Jagannathan Santhanam]

Hello
I am trying to generate an email to be sent to an operator if a SQL
Server (2000) goes down for any reason. I defined the alert to email
operator for error number "17148" which is "SQL Server is terminating
due to 'stop' request from Service Control Manager.". To test this, I
shutdown SQL Server manually. I see the above error in the Windows
Application Log, however, no emails are being sent to the Operator.
Also, when I open the Alert, I do not see that it occured. What am I
missing.

Thanks
Jagannathan Santhanam

[Steven Wilmot]

"Jagannathan Santhanam" <ja*****@yahoo.com> wrote in message
news:60**************************@posting.google.c om...

Hello
I am trying to generate an email to be sent to an operator if a SQL
Server (2000) goes down for any reason. I defined the alert to email
operator for error number "17148" which is "SQL Server is terminating
due to 'stop' request from Service Control Manager.". To test this, I
shutdown SQL Server manually. I see the above error in the Windows
Application Log, however, no emails are being sent to the Operator.
Also, when I open the Alert, I do not see that it occured. What am I
missing.

Thanks
Jagannathan Santhanam

Instead of using SQL to fire this, use Windows itself.

Windows allows you you to run a command upon service failure - link this in
with a command-line SMTP mailer (such as BLAT) and you have your alert.

Steven