Monitoring Failed Job Steps

• Leo Peysakhovich

  Hall of Fame

  Points: 3973

  More actions

  February 29, 2004 at 6:33 am

  #161166

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

• spongemagnet

  SSCrazy

  Points: 2812

  More actions

  March 1, 2005 at 10:39 am

  #544654

  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