How can I know the "SQL Server" Service is down ?

Dear,
How can I make a SQL Server able to send me an email alert if its SQL Server
Service and/or SQL Server Agent Service is down automatically ?
SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they can
monitor themselves.
Are there any other way to monitor them ? Either from Microsoft Windows
system or third party softwares.The simplest solution is to configure MOM (assuming you have deployed it).
Otherwise you need to do this in Windows. In the Computer Management -
Services node, display the properties pages of the services of interest and
configure the recovery page.
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ff47de$1@.127.0.0.1...
> Dear,
> How can I make a SQL Server able to send me an email alert if its SQL
> Server
> Service and/or SQL Server Agent Service is down automatically ?
> SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
> can
> monitor themselves.
> Are there any other way to monitor them ? Either from Microsoft Windows
> system or third party softwares.
>|||Dear Yudkin,
What does MOM stand for ?
Please tell me, thanks a lot.
"Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
> The simplest solution is to configure MOM (assuming you have deployed it).
> Otherwise you need to do this in Windows. In the Computer Management -
> Services node, display the properties pages of the services of interest
and
> configure the recovery page.
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:46ff47de$1@.127.0.0.1...
> > Dear,
> >
> > How can I make a SQL Server able to send me an email alert if its SQL
> > Server
> > Service and/or SQL Server Agent Service is down automatically ?
> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
> > can
> > monitor themselves.
> >
> > Are there any other way to monitor them ? Either from Microsoft Windows
> > system or third party softwares.
> >
> >
>|||> What does MOM stand for ?
Microsoft Operations Manager. See
http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ffa2bc$1@.127.0.0.1...
> Dear Yudkin,
> What does MOM stand for ?
> Please tell me, thanks a lot.
> "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
> news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
>> The simplest solution is to configure MOM (assuming you have deployed
>> it).
>> Otherwise you need to do this in Windows. In the Computer Management -
>> Services node, display the properties pages of the services of interest
> and
>> configure the recovery page.
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:46ff47de$1@.127.0.0.1...
>> > Dear,
>> >
>> > How can I make a SQL Server able to send me an email alert if its SQL
>> > Server
>> > Service and/or SQL Server Agent Service is down automatically ?
>> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
>> > can
>> > monitor themselves.
>> >
>> > Are there any other way to monitor them ? Either from Microsoft Windows
>> > system or third party softwares.
>> >
>> >
>>
>|||Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Od9MKe2AIHA.288@.TK2MSFTNGP02.phx.gbl...
> > What does MOM stand for ?
> Microsoft Operations Manager. See
> http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:46ffa2bc$1@.127.0.0.1...
> > Dear Yudkin,
> >
> > What does MOM stand for ?
> > Please tell me, thanks a lot.
> >
> > "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
> > news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
> >> The simplest solution is to configure MOM (assuming you have deployed
> >> it).
> >>
> >> Otherwise you need to do this in Windows. In the Computer Management -
> >> Services node, display the properties pages of the services of interest
> > and
> >> configure the recovery page.
> >>
> >> "cpchan" <cpchaney@.netvigator.com> wrote in message
> >> news:46ff47de$1@.127.0.0.1...
> >> > Dear,
> >> >
> >> > How can I make a SQL Server able to send me an email alert if its SQL
> >> > Server
> >> > Service and/or SQL Server Agent Service is down automatically ?
> >> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because
they
> >> > can
> >> > monitor themselves.
> >> >
> >> > Are there any other way to monitor them ? Either from Microsoft
Windows
> >> > system or third party softwares.
> >> >
> >> >
> >>
> >>
> >
> >
>|||Or (the poor man's approach) you can also write a WMI script using VBScript
that monitors the SQL Server service and sends an email when it goes down.
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ffb47d$1@.127.0.0.1...
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Od9MKe2AIHA.288@.TK2MSFTNGP02.phx.gbl...
>> > What does MOM stand for ?
>> Microsoft Operations Manager. See
>> http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
>>
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:46ffa2bc$1@.127.0.0.1...
>> > Dear Yudkin,
>> >
>> > What does MOM stand for ?
>> > Please tell me, thanks a lot.
>> >
>> > "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
>> > news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
>> >> The simplest solution is to configure MOM (assuming you have deployed
>> >> it).
>> >>
>> >> Otherwise you need to do this in Windows. In the Computer Management -
>> >> Services node, display the properties pages of the services of
>> >> interest
>> > and
>> >> configure the recovery page.
>> >>
>> >> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> >> news:46ff47de$1@.127.0.0.1...
>> >> > Dear,
>> >> >
>> >> > How can I make a SQL Server able to send me an email alert if its
>> >> > SQL
>> >> > Server
>> >> > Service and/or SQL Server Agent Service is down automatically ?
>> >> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because
> they
>> >> > can
>> >> > monitor themselves.
>> >> >
>> >> > Are there any other way to monitor them ? Either from Microsoft
> Windows
>> >> > system or third party softwares.
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>