|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: 2 days ago @ 10:56 AM
Points: 26,
Visits: 74
|
|
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
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040,
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!
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, March 11, 2010 3:24 AM
Points: 586,
Visits: 360
|
|
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
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, July 06, 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
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, November 26, 2009 7:52 AM
Points: 500,
Visits: 162
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Friday, January 09, 2009 8:26 AM
Points: 1,
Visits: 25
|
|
| Thanks so much henrik staun poulsen. You saved my day.
|
|
|
|
|
Forum 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!
|
|
|
|
|
Forum 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!!!!!!!! 
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, March 02, 2010 1:53 PM
Points: 10,
Visits: 47
|
|
Thank you Henrik. It works now!
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, June 10, 2009 10:47 AM
Points: 7,
Visits: 13
|
|
thanks a lot!
|
|
|
|
