Error in receiving mails from SQL SERVER Job
-
I created a SQL Job in my sql server and have set my email id to receive email on success / failure. When I execute the job, it fails in sending emails to my email id. It shows below error.
"Error: 22022: SQL Server Agent Error: The SqlServerAgent mail session is not running; check the mail profile and/or the SQLSererAgent Service startup account in the SQLServerAgent Properties Dialog."
I tried look into msdn help with this error code. It says, I would require exchange server setup to receive emails from this. But my outlook is configured with POP3 Server
.Is there any solution for this without changing my email connection to Outlook server?
Regards,
Mahesh
-
did you try starting the mail session with xp_startmail. If so did that throw any error. Please try that and let us know whats the error that posts in when you fire the query.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
I tried with xp_startmail. It gives me following error.
"xp_startmail: failed with mail error 0x80040111" I looked into BOL with this error. It says to upgrade to latest SP. Even after upgrading to SP4 (8.00.2039), still it shows the same error.
I tried with NT & SQL Server authentication, still it gives me the same error.
Regards,
Mahesh
-
Log in with the account used to run SQL Server (the service account). Run outlook and check the profile, be sure it can send and receive. Likely something is misconfigured here.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
My outlook is configured with POP3 and i am able to send & receive mails from my outlook.
regards
Mahesh
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply