Post reply

Failed to notify ''operator name'' via email?

  • February 12, 2008 at 5:07 am

    #777279

    Fantastic, that did the trick.

    Thanks very much

  • March 26, 2008 at 5:01 am

    #793936

    Many thanks for that. You've saved me many hours of looking for the solution 😀

  • April 25, 2008 at 2:06 pm

    #807397

    Thanks a lot guys. Made the suggested change it works now.

    You made my day 😎

  • June 26, 2008 at 2:40 am

    #834466

    A restart was enough (after activating dbmail), thanks!

  • September 11, 2008 at 3:10 am

    #870172

    Thanks Henrik - that's been bugging me for months!

  • February 6, 2009 at 12:31 pm

    #939737

    Very nice. Nothing in my instructions about setting this up said anything about needing to enable Database Mail by checking that box. Thank you, Henrik!

  • February 7, 2009 at 11:53 am

    #940035

    Even a blind hen can sometimes find her corn.

    Thank you all for the kind words.

    Best regards,

    Henrik Staun Poulsen

    Stovi Software

  • March 3, 2009 at 4:02 am

    #952307

    Thanks.

  • March 19, 2009 at 1:15 pm

    #963056

    Awesome, thanks a TON!

  • April 28, 2009 at 7:02 am

    #985036

    Thanks! You saved the bacon.

  • May 1, 2009 at 1:17 pm

    #987535

    Hey,

    This is very very helpful...I really appreciate it.

  • June 25, 2009 at 5:16 am

    #1015210

    Thanks!!

  • July 9, 2009 at 8:16 am

    #1022392

    Thanks Henrik.

  • August 13, 2009 at 9:20 am

    #1038776

    I know this thread is old, but this is exactly why it is so important to have this resource.

    I am a relatively new, self taught DBA, totally relying on sites like SQL Server Central for my training, and I had the problem that started this thread this morning - a job failed, and failed to email me about it, though I thought I had everything set up perfectly, including turning on Database mail in SQL Agent --> Properties. The only step I didn't do, and didn't see documented ANYWHERE but here, was to restart the SQL Server Agent.

    My heartfelt thanks go out, first to the person who posted that nugget, and second to the whole SQL Server community, for their willingness to help! Every one of you is greatly appreciated!

  • September 1, 2009 at 7:25 am

    #1047506

    I struggled with this for most of the day yesterday. I searched and searched, googled and googled, with no workable solution. Just about every thread and blog I read recommended restarting the SQL Server Agent and this seemed to work for most people, but alas, would not work for me. Today, I came in with some fresh coffee and fresh perspective and figured it out.

    Using SS2K8, Windows Server 2008, 32x, everything lives on one machine.

    Sending a test email from Database mail worked.

    Message from Job History:

    "The job succeeded. The Job was invoked by User...bla bla bla...NOTE: Failed to notify 'me' via email."

    From Agent Error Log:

    "[264] An attempt was made to send an email when no email session has been established."

    Tried the following Solutions:

    In SQL Server Agent Properties >> Alert System >> checked Enabled mail profile.

    In Surface Area Configuration (which has been moved to Facets in SS2K8, btw) >> DatabaseMailEnabled = True.

    Deleted and recreated both mail profile and operator.

    Restarted Server Agent like a bazillion times.

    The ultimate solution (I can tell you are on the edge of your seat, nice desk chair by the way, no, really):

    Under Database Mail Configuration >> SMTP Authentication >> changed from Basic authentication to Anonymous authentication >>restarted Server Agent >>crossed fingers for good luck.

    No, seriously, that was it. Don't ask me why it worked, but it worked. Hopes this helps someone.

Viewing 15 posts - 16 through 30 (of 75 total)

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