Post reply

SQL Server Agent Not sending notification emails

  • February 7, 2012 at 5:48 pm

    #250439

    I have setup a database mail profile and account.

    I am able to send test emails to my work email by right clicking the database mail.

    But I am getting any emails via SQL Server agent(I have given the same email id for the operator) for job completion or failure...

    I tried to restart SQL SERVER AGENT to see if it fixes the problem...

    no luck...

    have you guys come across this kind of a problem before..??

  • February 7, 2012 at 10:31 pm

    #1444281

    Hi,

    Hope you change the setting in 'Job', some option is available failover/Success. Please recheck once, definetely you will get...

  • February 9, 2012 at 5:45 am

    #1445013

    Did you enable Alerts within the property section of SQL Agent? Right click SQL Server Agent->Properties->Alert System-> Enable mail profile. Then restart agent and try again.

  • February 9, 2012 at 9:29 am

    #1445155

    Hi,

    Thanks for looking into my question...I forgot to enable the mail profile in SQL Server Agent...That solved the issue..

    Thanks!!

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

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