AnsweredAssumed Answered

How to create a report linking OH and JPP showing process flows, jobs and schedules

Question asked by Peter_W_1520 on Aug 18, 2014
Latest reply on Aug 19, 2014 by Jessica_Isaacson_255
Hello gurus,
Have been scratching my head trying to work this out.
I want to create a query for OM8 that shows the objects (jobs & process flows) linked to a schedule. 
I know the links are in the OH and JPP tables, but having issues writing the query (in Oracle 11g). 
I saw Philipp's brilliant SQL but having difficulties adapting it to run with Oracle.

If anyone can help that would be great.

TIA
Peter

 

Outcomes