Database Reference
In-Depth Information
EM Job Schema
More than 70
JOB
tables exist in the
SYSMAN
schema, but only a few are involved in the major components of the EM
Job System and require a basic understanding. You can execute queries against these tables for a more difinitive view
of the EM Job environment. Figure
11-10
shows two main tables, along with the relationships between objects.
Figure 11-10.
Note the columns for joining the most common objects in the EM Job System part of the
SYSMAN
schema
The following example queries will report against job data. The
MGMT_JOB
table, which is often used in the
upcoming queries, contains both the Job Library and the
job_activity
information, so this must be kept in mind
when querying, as shown in Figure
11-11
. Often this data is essential if at any time the EM Job Activity or Job
Library interface is unsuccessful at managing a job and the Enterprise Manager Command Line Interface (EMCLI)
must be used.