AnsweredAssumed Answered

SQL Query for last failed job in a workflow

Question asked by Heather_Silverstein_8545 on Oct 24, 2016
Latest reply on Oct 26, 2016 by joel_wiesmann_automic
I am trying to query the database for failed jobs, but only return the job that was the actual root cause for the failure (not the related jobs which also display failed status codes). Since the timestamps do not include HH:MM I am not able to use this attribute in a helpful way. Is there another table or attribute that could help filter these results? AH_TimePeriod is null for all results.