Monitoring Failed Job Steps

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Leo Peysakhovich » Monitoring Failed Job Steps

Monitoring Failed Job Steps

Rate Topic

Display Mode

Topic Options

Author

Message

Leo Peysakhovich

Posted Sunday, February 29, 2004 6:33 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129, Visits: 205

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/l

Post #103193

spongemagnet

Posted Tuesday, March 01, 2005 10:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 4:08 PM
Points: 172, Visits: 272

That's an interesting approach. I've devised a system where i have a table storing job and step id's, recipients, and on_success/on_fail fields and a trigger on sysjobstephistory. Though both ways are effective, your method seems easier to implement, and slightly less dependant on the system tables.

-Ken

Post #164741

« Prev Topic | Next Topic »

Permissions