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: Wednesday, February 26, 2014 12:36 PM
Points: 256, Visits: 1,063
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 08, 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 06, 2014 4:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 2:47 AM
Points: 1, Visits: 8
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: Friday, April 11, 2014 6:38 PM
Points: 1, Visits: 38
Excellent Post, Thanks as well!!!
Post #1561158
« Prev Topic | Next Topic »

Add to briefcase «««34567

Permissions Expand / Collapse