Post reply

database mail not sending to operators

  • July 19, 2011 at 4:18 pm

    #240181

    Message

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-07-19T14:35:01). Exception Message: Cannot send mails to mail server. (A recipient must be specified.).

    I can send a test e-mail using the full e-mail address but not when I use the operator.

  • July 19, 2011 at 4:35 pm

    #1355213

    Have you enabled a mail profile for SQL Agent?

    See here

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 19, 2011 at 4:35 pm

    #1355214

    Do you mean that you can send mail when you test the profile but when you use SQLserver agent and operator it fails.

    If this is the case, ensure sp_configure 'agent xps' are enabled.

    You can also ensure your operator mail is linked to a job, once that is done

    restart your agent, you don't need to restart SQL but you need to give the agent a boot.

    Cheers

    Jannie

  • July 19, 2011 at 4:39 pm

    #1355217

    The operator is enabled.

    The SQL agent mail profile is enabled.

  • July 19, 2011 at 4:44 pm

    #1355220

    Jannie-186227 (7/19/2011)

    Do you mean that you can send mail when you test the profile but when you use SQLserver agent and operator it fails.

    Yes, everything works when I use r@msn.com but when I use the operator 'rtest' I get the error in my original post.

    If this is the case, ensure sp_configure 'agent xps' are enabled.

    How do I do that?

  • July 19, 2011 at 4:52 pm

    #1355225

    Have you restarted the agent ?

    exec sp_configure 'agent xp', 1

    reconfigure

  • July 19, 2011 at 4:53 pm

    #1355226

    Here is the technet article on enabling agent xps

    http://technet.microsoft.com/en-us/library/ms178127.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 19, 2011 at 4:58 pm

    #1355229

    Okay,

    After going onto the server itself and restarting the SQL Server Agent (after two hours of beating up on the server) everything seems ok.

    Thanks everyone!

  • July 19, 2011 at 5:03 pm

    #1355233

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply