Post reply

SetUp Mail Notifications with Jobs failure

  • January 12, 2012 at 1:21 pm

    #253444

    Hi All,

    To new to know what to do here. Using SQL Server 2008 R2. Setup DB mail and restarted Agent service but mail notification on jobs still fails. Not sure what I am missing.

    Any help is truly appreciated!!!!!!!!!

    Thanks in advance,

    d

  • January 12, 2012 at 1:34 pm

    #1432862

    Look at you Mail Session properties to make sure it is active.

    SQL Server Management Studio --> Connect to the SQL Instance in question.

    Right Click on the SQL Server Agent. Click on Properties. Click on Alert System.

    check to make sure your Enable Mail Profile box is checked and that you see your Mail system and Mail Profile as options to choose from.

  • January 12, 2012 at 2:40 pm

    #1432902

    If you find that you have to enable the profile under SQL Agent, Alert System, you'll have to bounce SQL Agent for the change to take effect.

  • January 13, 2012 at 6:12 am

    #1433179

    You say you set up DBMail, but did you set up Operators?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 13, 2012 at 6:29 am

    #1433185

    Hi ALL. Thanks for the replies. I really appreciate the help in knowing what I am missing here....

    Hi Geoff,

    My agent properties show enabled and the Mail system is set to Database Mail. Which option do I want for the Mail Profile? Choices are SQL Server Agent Mail (which is chosen) or SQL Server Mail Profile?

    Hi Chuck,

    Agent property does show enabled.

    Hi Brandie,

    Yes, I did set up an Operator. Is there anything special I need to do here other than create it and point to it in the Notification section of the job?

    Thanks again!!!

    Denise

  • January 13, 2012 at 6:46 am

    #1433195

    You've followed all the steps below?

    Microsoft's DBMail Wizard Steps

    Pinal Dave has a more user-friendly version here[/url].

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 13, 2012 at 9:14 am

    #1433337

    This is a great alternative to setting up mail notifications on jobs without using SQL mail. It does have some limitations, but for failure/success notifications, it's great. And it's way less confusing to set up than SQL mail.

    http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/

    Cheers.

    Tom

  • January 13, 2012 at 9:18 am

    #1433349

    thotvedt (1/13/2012)

    This is a great alternative to setting up mail notifications on jobs without using SQL mail. It does have some limitations, but for failure/success notifications, it's great. And it's way less confusing to set up than SQL mail.

    SQL Mail no longer exists in 2008. DBMail is a different animal.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 13, 2012 at 9:51 am

    #1433400

    HI Brandie,

    It looks like everything is fine and I am able to send a test email successfully but still no email job notification upon job completion (and yes I did check to see if it was set to send when complete) 🙂

    Missing something here....

  • January 13, 2012 at 9:59 am

    #1433409

    olingerd (1/13/2012)

    HI Brandie,

    It looks like everything is fine and I am able to send a test email successfully but still no email job notification upon job completion (and yes I did check to see if it was set to send when complete) 🙂

    Missing something here....

    yes, and I bet I know what it is, but ... tip of my tongue and all that.

    I'm going to do a bit of research and get back to you as soon as I remember what that darned issue is.

    BTW, is the profile set to public? (This isn't what I'm thinking of, but it's good to know).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 13, 2012 at 10:08 am

    #1433413

    Public is checked

    Please know that I truly appreciate your help!!!!!

  • December 4, 2012 at 6:06 am

    #1565254

    Right click SQL Server agent and go to the properties.

    Then make sure that Enable mail profile option is enabled. select Mail system as: Database Mail and select Mail profile as : (the name of the mail profile you already created)

    Click OK then restart SQL Server agent.

    Regards,

    Qais Al-Shalabi

  • December 4, 2012 at 6:07 am

    #1565255

    Right click SQL Server agent and go to the properties.

    Then make sure that Enable mail profile option is enabled. select Mail system as: Database Mail and select Mail profile as : (the name of the mail profile you already created)

    Click OK then restart SQL Server agent.

    Regards,

    Qais Al-Shalabi

  • December 4, 2012 at 9:41 am

    #1565402

    If the test is working, but when your plan runs you aren't getting notified, perhaps it's the constraints that you're using for the notify operator task. Do you have it set to notify upon success, failure, or completion?

    ----------------------------------------------------------
    Gifting myself with technology related headaches since 2005!

Viewing 14 posts - 1 through 13 (of 13 total)

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