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.