Post reply

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

  • September 1, 2009 at 7:57 am

    #1047538

    thanx henrik staun poulsen...

    navnet lyder dansk =) ... såe,, endnu engang TAK

  • September 30, 2009 at 4:17 pm

    #1060221

    That worked. Thanks!!

  • October 1, 2009 at 3:52 am

    #1060349

    sdfsdfsdfsdf

  • October 6, 2009 at 5:45 pm

    #1062551

    I had the same issue. This solved it. Thank you.

  • November 24, 2009 at 5:00 pm

    #1083746

    Thank you!! It works now!

  • April 6, 2010 at 8:30 am

    #1146523

    Amazing how a solution from 2006 is still very useful in 2010.

    Thanks a lot, finally got Database Mail from a SQL Server Agent Job to work! 🙂

  • May 5, 2010 at 4:35 pm

    #1162865

    I had the same problem where the Test email would work just fine, but the notification at the end of processing a job was failing. The setting was turned on for alerts for "Enable mail profile" but apparently SQL server wasn't seeing this as valid.

    My solution was from within management studio:

    1) SQL Server Agent (right Click) -> Properties -> Alert System -> Unselect "Enable Mail Profile"

    2) restart the SQL Server Agent (right click -> restart)

    3) SQL Server Agent (right Click) -> Properties -> Alert System -> Check "Enable Mail Profile" (yes, i know it was on before this process started)

    4) Restart the SQL Server Agent again.

    After this process, I was successfully able to send notifications to the Operators.

    Eric B.

  • May 27, 2010 at 7:45 am

    #1173315

    It worked Great. Thanks for the post.

  • August 30, 2010 at 10:49 am

    #1213838

    Old thread, but +1.

  • September 6, 2010 at 12:38 am

    #1216768

    That was really helpful..this is an amazing forum..Thanks alot!!

  • September 6, 2010 at 2:34 am

    #1216799

    thanks!! 🙂

  • September 7, 2010 at 10:39 am

    #1217439

    Henrik, It helped me too! Thanks a Million!

  • September 8, 2010 at 4:35 am

    #1217829

    I'm glad it helped, even if this thread is getting a bit old 🙂

  • September 8, 2010 at 6:23 pm

    #1218313

    I found one cause for issues for everything but sql agent job alert notifications working. The original DBMail setup stores the default profile in the registry when you setup DBMail for first time. Stupid idea of MS. Anyways, SQL agent reads it only when it starts up. So, if you have a bad profile name in there agent notifications won't work and you won't get any log information other than job failure message: "NOTE: Failed to notify 'OperatorName' via email."

    Use this to read the entry:

    EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'DatabaseMailProfile'

    Use this to update it:

    select 'exec master.dbo.xp_instance_regwrite N''HKEY_LOCAL_MACHINE'', N''SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent'', N''DatabaseMailProfile'', N''REG_SZ'', N''' + name + ''''

    from msdb.dbo.sysmail_profile

    where profile_id in (Select profile_id from msdb.dbo.sysmail_principalprofile Where is_default = 1 and principal_sid = 0)

    SQL Agent restart is required.

    I submitted a Connect item https://connect.microsoft.com/SQLServer/feedback/details/596305/database-mail-configuration please vote it up.

    HTH,

    -Chuck

    @SQLGuyChuck

  • September 23, 2010 at 6:32 am

    #1226267

    Thanks A lot.......Great help:-)

Viewing 15 posts - 31 through 45 (of 75 total)

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