Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Failed to notify ''operator name'' via email? Expand / Collapse
Author
Message
Posted Wednesday, January 25, 2006 2:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 25, 2011 7:53 AM
Points: 27, Visits: 97
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
Post #253575
Posted Monday, January 30, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #254409
Posted Friday, February 17, 2006 3:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 8:07 AM
Points: 1,363, Visits: 989
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



Post #259344
Posted Friday, April 21, 2006 5:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 6, 2006 1:45 AM
Points: 1, Visits: 1

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

Post #274429
Posted Thursday, April 27, 2006 8:00 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 6, 2012 9:12 AM
Points: 500, Visits: 183

Thank you henrik staun poulsen.

That was a big help!



Skål - jh
Post #275866
Posted Friday, April 28, 2006 2:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 9, 2009 8:26 AM
Points: 1, Visits: 25
Thanks so much henrik staun poulsen. You saved my day.
Post #276400
Posted Tuesday, June 27, 2006 1:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 10, 2008 7:04 AM
Points: 1, Visits: 2
It helped me too!  Thanks a bunch!
Post #290558
Posted Tuesday, April 10, 2007 11:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 17, 2008 9:19 AM
Points: 1, Visits: 4

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!!!!!!!! 

Post #357278
Posted Wednesday, May 23, 2007 12:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 9:30 AM
Points: 17, Visits: 172
Thank you Henrik. It works now!


Post #368377
Posted Friday, June 8, 2007 3:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 10, 2009 10:47 AM
Points: 7, Visits: 13
thanks a lot!
Post #372506
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse