Post reply

Job Email Notification Failure

  • November 1, 2011 at 11:19 pm

    #251051

    Hi,

    We have successfully configured Database Mail SQL Server 2008 Enterprise Edition and also its working fine. But when I tried to test it via job notification, it is failing.

    Message: NOTE: Failed to notify via email.

    Please let me how can I resolve this issue and go forward in this regard.

    Thanks,

    Sudheer

  • November 2, 2011 at 12:44 am

    #1401981

    hi!

    you may refer to this site for configuring Database Mail!

    http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

    ===============================================================

    "lets do amazing" our company motto..

  • November 2, 2011 at 1:14 am

    #1401989

    Hi,

    This is Siri, sudheer's colleague and we are presently handling the issue regarding the Job Email Notification Failure in SQL Server 2008. Your help is much appreciated.

    We have configured the DB Mail already and also tested in many ways. We have received all the test emails which were used for testing in case of Database Mail.

    The issue we are facing is that, the email is notification is failing in case jobs in SQL Server. The job is running successfully but the notification thru mail is failing. The operators used in this case are very much correct and we have also reverified them.

    Please let us know what cud be steps to have more checks in this failure of notification.

    Thanks,

    Siri

  • November 2, 2011 at 2:00 am

    #1401997

    hi you may use the technique below from todd engen.

    In SSMS select Database Mail under Management, right-click and Configure Database Mail. After that's complete send a test mail using the new profile to confirm that works.

    Next, open the properties of the SQL Server Agent. On the Alert System page enable the mail profile. Restart the SQL Server Agent for the change to take effect.

    Under the SQL Server agent create Operators to send messages to.

    Finally, in your job select Notifications and set the Operator to send to when the job completes.

    -Todd Engen

    ===============================================================

    "lets do amazing" our company motto..

  • November 2, 2011 at 2:40 am

    #1402005

    Whoohooo it workedd..Thank u so much for the help 🙂

    We have actually Enabled the Mail profile in the Agent yesterday but dint restart the Agent service...so thats the reson we were getting the mail while testing but unable to get it in the notification via Jobs.

    However we are happy that it worked..thnx once againn 🙂

  • November 2, 2011 at 2:41 am

    #1402006

    I fall in to this trap most of the time as well, never remeber to restart the Agent to get it to pick up the mail profile

  • November 2, 2011 at 2:44 am

    #1402011

    np siri.. 😀

    ===============================================================

    "lets do amazing" our company motto..

  • November 21, 2017 at 11:10 am

    #1969064

    My emails when the job fails stopped working last week when nothing has changed. Any ideas?

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

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