AnsweredAssumed Answered

SQL to get the current status of top most jobplans in a schedule

Question asked by ThomasM_8574 on Nov 3, 2016
Latest reply on Nov 3, 2016 by Wolfgang_Brueckler_1288
Hi Everyone ,

Am new to Automic and am exploring the backend DB tables for generating report.

Am trying to find the current status of all jobplans that are scheduled and running daily.

I got the required information from OH table but the Parent jobplan's status is always 0 even when one of the child job has failed or cancelled.

As of now , am using only the OH and AH tables in my Query .

I would greatly appreciate if someone point me in the right direction .