none
SQL Server Agent Jobs are not sending notification emails.

    คำถาม

  • Hi guys, hopefully someone could point me in the right direction. We have configured several maintenance plans to backup our databases. In the properties of the agent jobs we then set up notifications to be emailed if the job completes or is successful. However that is not working. It was working at one point, but since we have moved to sp3 it stopped. Database mail has been configured and we are able to send test emails. The operator has been added, and also mail has been enabled on the sql server agent properties itself. we have tried restarting the agent, deleting and recreating the database mail setup. Also used our secondary exchange server. Both servers work when we send test emails by right clicking on the database mail menu in the SSMS.

    we are able to get notifications using notification task within the sub-plans of the maintenance plans. However this should be working through the notifications through the agent jobs.

    Below is our environment
    sql server 2008 enterprise r2 64 bit
    server 2008 r2 enterprise, running as a vmware client on a vmware 4.0 server.
    1 มีนาคม 2555 17:21

คำตอบ

ตอบทั้งหมด

  • Hi Marlon Dyer,

    It seems that the Database Mail works ok, but cannot send the notification mail via SQL Server Agent job. Could you please check the configuration of the Alert System on the SQL Server Agent properties to see if you have enabled the notification with appropriate mail profile? Please have a look at this similar thread: SQL Server Agent Job Notifications Not Working.


    Stephanie Lv

    TechNet Community Support

    • ทำเครื่องหมายเป็นคำตอบโดย Stephanie Lv 19 มีนาคม 2555 7:47
    5 มีนาคม 2555 6:25
  • I realise this post is well old but I have this issue too at the moment and cannot find the answer anywhere.

    I have had it before too but last time I just restarted the Agent and it all worked. This time this is not helping.

    All settings are correct. I have to servers with identical configurations and one will send alerts but the other won't

    and yes, both have identical mail profiles and are set in the Agent for alerting.

    They can both send mail by

    EXEC dbo.sp_notify_operator
       @profile_name = N'myMailProfile',
       @name = N'DBA',
       @subject = N'Test Notification',
       @body = N'This is a test of notification via e-mail.' ;
    its just alertignthat does not work.

    Its infuriating. Surely a permissions thing but which? I even tried running the SQL Agent as a sysadmin!



    Web dev and DBA

    20 สิงหาคม 2556 15:09
  • I am having this exact same issue like David Bridge.  I can send test emails, dbo.sp_notify_operator works fine, but sql agent will simply not send an email...
    30 มกราคม 2557 19:38