Monitoring Failed Job Steps

  • Leo Peysakhovich

    Hall of Fame

    Points: 3880

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

  • spongemagnet

    SSCrazy

    Points: 2812

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply