January 25, 2006 at 2:52 pm
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
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
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
April 28, 2006 at 2:20 pm
Thanks so much henrik staun poulsen. You saved my day.
June 27, 2006 at 1:57 pm
It helped me too! Thanks a bunch!
April 10, 2007 at 11:58 am
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
Thank you Henrik. It works now!
June 8, 2007 at 3:23 pm
thanks a lot!
July 20, 2007 at 1:14 am
Big thanks to you!!!
September 19, 2007 at 6:06 am
Helped out another newbie!
September 27, 2007 at 2:03 am
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
thanks alot this worked right away:P
November 9, 2007 at 8:09 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy