Database Reference
In-Depth Information
Figure 11-47.
Results of a sample query, displayingall jobs with a name including BACKUP
Using the EMDIAG utility commandrepvfy, we can dump all data from the job into a log file by executing
the following:
$repvfy dump job -name BACKUP_APEX.1
Or again, we can query from SQL*Plus to gather the
STEP_ID
with data from the original query:
select mj.job_id, mj.job_name, mjh.execution_id, mjh.step_id
from sysman.mgmt_job mj, sysman.mgmt_job_history mjh
where mj.job_id = 'BFC78F41009876F3E04014AC08003231'
and mj.job_id=mjh.job_id
and mjh.start_time > sysdate-1;
Figure
11-48
shows an example of
JOB_ID
,
EXECUTION_ID
, and
STEP_ID
that can be used as we proceed through
the EMDIAG steps to dump data to the log files.
Figure 11-48.
An example of
JOB_ID
,
EXECUTION_ID
, and
STEP_ID
We then can use the
STEP_ID
and proceed to dump to log files more data about the job in question:
$repvfy dump step -id 1554907
The
STEP_ID
is also located in the last occurrence of the error in the
emoms.trc
file, located in the
$OMS_HOME/
gc_inst/em/EMGC_OMS1/sysman/log
. This trace file will direct you to the target and job information if for some reason
the information did not return in the query from SQL*Plus.