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

Send notifications on job STEP failures (trigger) Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 6:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 10:54 AM
Points: 194, Visits: 322
Comments posted to this topic are about the item Send notifications on job STEP failures (trigger)


-Ken
Post #401748
Posted Tuesday, September 29, 2009 8:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 15, 2014 3:36 PM
Points: 1,153, Visits: 542
This trigger works perfectly on my one server, however I created it on a second server and for some reason I don't receive the email. Database Mail is setup and I made the change to exec msdb.dbo.sp_send_dbmail. Of course my error message is Error: 50000 Severity: 16 State: 10. Has anyone had this problem? I'm not sure where to check to get an understanding of what went wrong. There is nothing helpful in msdb.dbo.sysmail_allitems or msdb.dbo.sysmail_event_log.

Thanks for you help.
Erin
Post #795178
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse