Sunday, February 19, 2012

Getting error 22022: SQLServerAgent Error

Hi,
I'm trying to configure the mail notification on SQL Server and I'm
getting the following error "Error 22022: SQLServerAgent error: The
SQLServerAgent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account ...". PLEASE HELP!!!!!
I really don't know where to look at, what to configure. I'm an Oracle
DBA, and sometimes SQL Server DBA, I know stuff on SQL Server but not
how to configure the mail notification. So if someone could help me to
solve this issue that would be great.
Thanks in advance
Patrick
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Hello Patrick
There are several steps in configuring SQLMail to be used with SQL and
SQLAgent. Basically SQLAgent is the scheduling engine for SQL Server and
runs as a separate service (shows up under Windows Services as
SQLServerAgent (or SQLAgent$<InstanceName> for named instances). This
service needs to be starting under a domain account which has access to the
mailbox (if using Exchange).
For more information I would advise you to look at the following articles :
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment