|
JOB
|
NUMBER
|
NOT NULL
|
Identifier of job. Neither import/export nor repeated executions change this value.
|
|
LOG_USER
|
VARCHAR2(30)
|
NOT NULL
|
Login user when the job was submitted
|
|
PRIV_USER
|
VARCHAR2(30)
|
NOT NULL
|
User whose default privileges apply to this job
|
|
SCHEMA_USER
|
VARCHAR2(30)
|
NOT NULL
|
Default schema used to parse the job
For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP
|
|
LAST_DATE
|
DATE
|
|
Date on which this job last successfully executed
|
|
LAST_SEC
|
VARCHAR2(8)
|
|
Same as LAST_DATE. This is when the last successful execution started.
|
|
THIS_DATE
|
DATE
|
|
Date that this job started executing (usually null if not executing)
|
|
THIS_SEC
|
VARCHAR2(8)
|
|
Same as THIS_DATE. This is when the last successful execution started.
|
|
NEXT_DATE
|
DATE
|
NOT NULL
|
Date that this job will next be executed
|
|
NEXT_SEC
|
VARCHAR2(8))
|
|
Same as NEXT_DATE. This is when the last successful execution started.
|
|
TOTAL_TIME
|
NUMBER
|
|
Total wall clock time spent by the system on this job, in seconds
|
|
BROKEN
|
VARCHAR2(1)
|
|
Y: no attempt is made to run this job
N: an attempt is made to run this job
|
|
INTERVAL
|
VARCHAR2(200)
|
NOT NULL
|
A date function, evaluated at the start of execution, becomes next NEXT_DATE
|
|
FAILURES
|
NUMBER
|
|
Number of times this job has started and failed since its last success
|
|
WHAT
|
VARCHAR2(4000)
|
|
Body of the anonymous PL/SQL block that this job executes
|
|
NLS_ENV
|
VARCHAR2(4000)
|
|
Session parameters describing the NLS environment of the job
|
|
MISC_ENV
|
RAW(32)
|
|
Other session parameters that apply to this job
|
|
INSTANCE
|
NUMBER
|
|
ID of the instance that can execute or is executing the job. The default is 0.
|
