Email report to Operator

While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks