3 Replies Latest reply on Jul 9, 2015 9:56 AM by Bill Robinson

    How to fetch job run events for deploy job phases at once?

    Yanick Girouard

      I'm trying to create a sql script that will dump all the logs of job that had errors so I can monitor everything more easily on a day to day basis. It works, but for deploy jobs, the job run event are associated with the specific phase (i.e. stage, simulate, apply, undo).


      I'm trying to figure out how to get the name of the parent deploy job and I can't find the link (table relationship to use). Would anyone be able to tell me?


      I'm usually able to figure it out on my own, but this one eludes me...