Post reply

Database Mail - Test email works, but Jobs won't send out Notifications

  • October 19, 2015 at 10:06 am

    #399208

    I am trying to send out notifications when jobs complete (fail or succeed). I have database mail working fine on my DEV server, but I am having issues with it on my PROD server. I am currently having people look into if McAfee may be blocking it, but wanted to check if anyone has any other ideas.

    I am able to send out a test email from SSMS>Management>Database Mail, but when I set a Notification for a job, the job will complete and in the history, it will say "NOTE: Failed to notify 'User' via email."

    I have created an Operator and set up Profiles and Accounts, just as I did on my DEV server.

    Anyone have any ideas?

  • October 19, 2015 at 3:30 pm

    #1834216

    did you enable the mail profile for SQL agent? right-click SQL Server Agent, choose properties and go to alert system page.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • October 20, 2015 at 8:06 am

    #1834384

    Robert is right... check that. I missed that on one of mine once and a forum poster helped me with that. I believe you have to restart SQL Agent service after you enable it to send mail as well.

Viewing 3 posts - 1 through 3 (of 3 total)

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