SQLServerCentral / Discuss Content Posted by Leo Peysakhovich / Article Discussions / Article Discussions by Author / Monitoring Failed Job Steps / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 21:40:28 GMT20RE: Monitoring Failed Job Stepshttp://www.sqlservercentral.com/Forums/Topic103193-163-1.aspxThat'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. Tue, 01 Mar 2005 10:39:00 GMTspongemagnetMonitoring Failed Job Stepshttp://www.sqlservercentral.com/Forums/Topic103193-163-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/lPeysakhovich/monitoringfailedjobsteps.asp>http://www.sqlservercentral.com/columnists/lSun, 29 Feb 2004 06:33:00 GMTLeo Peysakhovich