|
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 MEXT_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. |
