Post reply

Error in receiving mails from SQL SERVER Job

  • June 10, 2007 at 11:42 pm

    #117516

    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

  • June 11, 2007 at 2:03 am

    #711918

    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

  • June 19, 2007 at 8:04 am

    #713840

    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

  • June 19, 2007 at 8:22 am

    #713846

    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.

  • June 20, 2007 at 6:12 am

    #714066

    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