alert

Hi
I have SQL Server Mail configured and working correctly, but I was just
wondering if it were possible to send an e-mail alert to an operator
indicating that a SQL Server service had stopped? If so, how do I go about it?
Thanks
Hi
Write a stored procedure that trying to ping the server. If it got 'time out
...' then send the email.
"jonjo" <jonjo@.discussions.microsoft.com> wrote in message
news:6312060A-0A9A-4D3D-BC38-BE221D10B87C@.microsoft.com...
> Hi
> I have SQL Server Mail configured and working correctly, but I was just
> wondering if it were possible to send an e-mail alert to an operator
> indicating that a SQL Server service had stopped? If so, how do I go about
it?
> Thanks
|||Hi
Thanks for the reply. I've not done much development or sp work so could you
point me in the right direction as how to start writing the sp in question?
Thanks
"Uri Dimant" wrote:

> Hi
> Write a stored procedure that trying to ping the server. If it got 'time out
> ...' then send the email.
>
>
> "jonjo" <jonjo@.discussions.microsoft.com> wrote in message
> news:6312060A-0A9A-4D3D-BC38-BE221D10B87C@.microsoft.com...
> it?
>
>
|||Hi
I think you'd be better off finding a moitoring tool that can monitor the
SQL server service, and then let this tool email you when the service is
down. Additonally, if you use SQL Server Agent to do the monitoring, I doubt
that you can trust the result to check the server it self. SQL Server Agent
requires MSSQLSERVER to be running, so if the SQLserver service is down, SQL
server agent is most likely down as well.
Regards
Steen
jonjo wrote:[vbcol=seagreen]
> Hi
> Thanks for the reply. I've not done much development or sp work so
> could you point me in the right direction as how to start writing the
> sp in question?
> Thanks
> "Uri Dimant" wrote: