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 «««34567

Failed to notify ''operator name'' via email? Expand / Collapse
Author
Message
Posted Tuesday, December 11, 2012 9:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:07 AM
Points: 1, Visits: 16
Got the same problem over here, google it, found this thread and... it resolved my problem !!

Thank you
Post #1395206
Posted Wednesday, December 12, 2012 2:49 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:35 PM
Points: 259, Visits: 1,086
I recently encountered a situation on a new server (SS2012) where I wanted an email notification if any SQL Agent job failed to execute to successful completion but could not get it to work. I never had the problem before. ????

To test it, I created a SQL Agent job with a T-SQL script that was bound to fail, executed it, and no email message was received.

To make a long research story short, placing this short T-SQL script at the beginning of all SQL Agent jobs' T-SQL scripts solves the problem:

"SET XACT_ABORT ON"
Post #1395893
Posted Tuesday, January 8, 2013 5:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 11, 2013 8:07 AM
Points: 1, Visits: 2
It works 4 m... Thanks
Post #1404191
Posted Tuesday, October 15, 2013 11:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 2:57 PM
Points: 1, Visits: 95
This was the answer I needed. Thanks.

Post #1504888
Posted Wednesday, October 23, 2013 10:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 4:27 PM
Points: 3, Visits: 40
hey, very helpful information!
Post #1507751
Posted Monday, January 6, 2014 4:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 4:40 AM
Points: 1, Visits: 13
TNX!! helped me a lot!
Post #1528035
Posted Friday, April 11, 2014 6:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:46 AM
Points: 1, Visits: 52
Excellent Post, Thanks as well!!!
Post #1561158
Posted Wednesday, April 23, 2014 10:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 5:09 PM
Points: 83, Visits: 32
Gerd Hoefler (4/21/2006)


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: <A href="mailto:gerd.hoefler@gmx.at">gerd.hoefler@gmx.at</A>

Gerd

8 years and 2 days, several versions of SQL and this post still helps...
Post #1564511
Posted Thursday, April 24, 2014 7:33 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:35 PM
Points: 259, Visits: 1,086
I sometimes see criticism of posting on old threads. I think the criticism is misplaced.

Good information is never antiquated.
Post #1564652
Posted Tuesday, May 6, 2014 3:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:35 PM
Points: 32, Visits: 58
henrik staun poulsen (2/17/2006)
I just had the same problem.
Ihad 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.serverwith the topic "How to setup Operator for sending alerts?"

HIH
Henrik Staun Poulsen


8 years later, this is still relevant.... thanks, that was causing my problem today :) Two servers, one with this set right and one it got missed on and we couldn't figure out why some jobs notified upon failure and others didn't.
Post #1568203
« Prev Topic | Next Topic »

Add to briefcase «««34567

Permissions Expand / Collapse