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]

Re: SQL Server Alerts...


"Jagannatha n Santhanam" <jags_32@yahoo. com> wrote in message
news:605df08e.0 404300936.78517 f36@posting.goo gle.com...[color=blue]
> 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[/color]

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