Post reply

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

  • January 25, 2006 at 2:52 pm

    #170186

    Following command sends email fine:

    EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test

    message'

    However, SQL Job with a notification to above operator doesn't work.

    Job history comfortably mentions following with no other clues:

    NOTE: Failed to notify 'operator name' via email.

    What's wrong here, any ideas??

    Thanks

    AJ

  • January 30, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • February 17, 2006 at 3:47 am

    #621590

    I just had the same problem.

    I had to enable DatabaseMail on the SQL Server Agent -> properties -> Alert System  (check the checkbox), and then restart SQL Server Agent.

    It works now, thanks to a posting by "Johnny" in microsoft.public.sqlserver.server with the topic "How to setup Operator for sending alerts?"

    HIH

    Henrik Staun Poulsen

  • April 21, 2006 at 5:08 am

    #633456

    Hi all,

    some time ago i had the same problem.

    I fixed this and make a docu to solve this.

    But i have no idea how i can post this document here.

    If everyone would have this, send me a mail: gerd.hoefler@gmx.at

    Gerd

  • April 27, 2006 at 8:00 am

    #634583

    Thank you henrik staun poulsen.

    That was a big help!

    Skål - jh

  • April 28, 2006 at 2:20 pm

    #635003

    Thanks so much henrik staun poulsen. You saved my day.

  • June 27, 2006 at 1:57 pm

    #646202

    It helped me too!  Thanks a bunch!

  • April 10, 2007 at 11:58 am

    #699622

    I am a new installer and configurater of SQL 2005 and just tuned in today and you guys really helped me with the Database Mail feature, to get it configured correctly.

    Thanks a million to all!!!!!!!! 

  • May 23, 2007 at 12:33 pm

    #708412

    Thank you Henrik. It works now!

  • June 8, 2007 at 3:23 pm

    #711806

    thanks a lot!

  • July 20, 2007 at 1:14 am

    #721018

    Big thanks to you!!!

  • September 19, 2007 at 6:06 am

    #734537

    Helped out another newbie!

  • September 27, 2007 at 2:03 am

    #736642

    Thanks Henrik.

    The SQL Server Surface Area Configuration - Surface Area Configuration for Features - Database Engine - Database Mail was enabled, the msdb..sp_send_dbmail gave no errors, but I couldn't find the problem.

    Enabling the SQL Server Agent -> properties -> Alert System, and then restart SQL Server Agent was the solution.

  • October 17, 2007 at 9:40 am

    #742785

    thanks alot this worked right away:P

  • November 9, 2007 at 8:09 am

    #749865

    Thanks M8, you saved my time, I had done that on another instance but crazy me, thanks indeed.

Viewing 15 posts - 1 through 15 (of 75 total)

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