Find OEM Job Execution Output via sqlplus
Environment: OEM 12.1.0.5 BP3
Previously when running DB clone jobs in classic mode we could find the job output using sql such as:
SELECT *
FROM MGMG$JOB_STEP_HISTORY
WHERE execution_id = <job execution id>
ORDER BY start_time;
We could then see the CLOB data and find errors or export the info and search on it using familiar tools.
Now with the new Provisioning Wizard and subsequent jobs we do not see this information any more.
Does anyone know how to get the more detailed steps and clob output for the provisioning jobs?
Thanks,
-Mark