To get the Job stats based on OH, AH and JPP Tables

Discussion created by SudharsonNarayanamoorthy603801 on Jan 4, 2018
Latest reply on Jan 8, 2018 by SudharsonNarayanamoorthy603801

I would like to query UC4 tables to get stats of all jobs that runs at specific time slot (to be decided). Requirement is to retrieve JOB NAME, CHAIN NAME (Chain to which the batch corresponds to), Job's START TIME, Job's END TIME. I mapped OH Table ID (Column = oh_idnr) JPP table ID (JPP_OH_IDNR) and AH table ID. But I'm able to get only CHAIN's START TIME and END TIME whereas unable to retrieve individual jobs timestamp. 

Can someone help me ?