Wednesday, March 21, 2012

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!!!!
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

No comments:

Post a Comment