Enterprise Manager Generic (MOSC)

MOSC Banner

Find OEM Job Execution Output via sqlplus

edited May 16, 2017 5:00AM in Enterprise Manager Generic (MOSC) 1 commentAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center