Question of SQLAgentMail and SQL Mail

Hi,
I need monitoring scheduling jobs, alerts and database
maintenance from daily manually checks to automation. If
any of them failed while execute, it should be
automatically email to operator. I knew it can be done by
configuring SQLAgentMail and SQL Mail, but how to
configuring? Any particular software need install such as
MS exchange server to the production SQL Server or other
requests? Also can anyone tell which link I should to
follow?
Thanks for all the help!
-Jennyhttp://www.aspfaq.com/2403
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Jenny" <jey@.iseoptions.com> wrote in message
news:601201c474df$220c7fb0$a401280a@.phx.gbl...
> Hi,
> I need monitoring scheduling jobs, alerts and database
> maintenance from daily manually checks to automation. If
> any of them failed while execute, it should be
> automatically email to operator. I knew it can be done by
> configuring SQLAgentMail and SQL Mail, but how to
> configuring? Any particular software need install such as
> MS exchange server to the production SQL Server or other
> requests? Also can anyone tell which link I should to
> follow?
> Thanks for all the help!
> -Jenny
>|||Have a look at
SQL Mail
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321183
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293
Support Web Cast
http://support.microsoft.com/servicedesks/webcasts/wc091301/wcblurb091301.asp
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenny" <jey@.iseoptions.com> wrote in message
news:601201c474df$220c7fb0$a401280a@.phx.gbl...
> Hi,
> I need monitoring scheduling jobs, alerts and database
> maintenance from daily manually checks to automation. If
> any of them failed while execute, it should be
> automatically email to operator. I knew it can be done by
> configuring SQLAgentMail and SQL Mail, but how to
> configuring? Any particular software need install such as
> MS exchange server to the production SQL Server or other
> requests? Also can anyone tell which link I should to
> follow?
> Thanks for all the help!
> -Jenny
>