SQL Server Alerts... -- sql server (alternate)

jags_32 NO[at]SPAM yahoo.com
4/30/2004 10:36:44 AM

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

Steven Wilmot
5/3/2004 7:31:56 PM

[quoted text, click to view]

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

sql server (alternate) : SQL Server Alerts...