locked
Maintanance plan not sending email after completion RRS feed

  • Question

  • SQL 2012 Availability group environment
    There are three servers into Availability group.

    Setup DB mail on three servers
    Create maintenance plans

    excute maintenance plan on each servers
    DB mails works on two servers after completion of maintenance plan

    There is one server out of three not sending emails after completion of maintenance job but successfully send test mails using DBMail email and command prompt.

     


    Muhammad Mehdi

    Wednesday, July 22, 2015 8:52 PM

Answers

  • is the notification coming from sql sgent job , if you make sure the on the sql server agent - alert system is configured and this requires a of sql server agent.

    right click on the sql server agent - properties-- alert system -- database mail

    make sure it is configured and test it. you will need to restart to this effect


    Hope it Helps!!


    • Edited by Stan210 Wednesday, July 22, 2015 9:08 PM
    • Marked as answer by MM from AUS Thursday, July 23, 2015 8:31 PM
    Wednesday, July 22, 2015 9:08 PM

All replies

  • is the notification coming from sql sgent job , if you make sure the on the sql server agent - alert system is configured and this requires a of sql server agent.

    right click on the sql server agent - properties-- alert system -- database mail

    make sure it is configured and test it. you will need to restart to this effect


    Hope it Helps!!


    • Edited by Stan210 Wednesday, July 22, 2015 9:08 PM
    • Marked as answer by MM from AUS Thursday, July 23, 2015 8:31 PM
    Wednesday, July 22, 2015 9:08 PM
  • Email setup is configured under maintenance plan configuration as per below screenshot


    Muhammad Mehdi

    Wednesday, July 22, 2015 9:31 PM
  • yes, i am not sure whether you have observed or not, it says - sql agent should already be configure with database mail ..so, please check things I mentioned above and make sure you are receiving email alerts from sql server agent..


    Hope it Helps!!

    Thursday, July 23, 2015 4:23 AM