| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_JOBS describes all jobs in the database that are accessible to the current user.
See Also:
Oracle Database Administrator's GuideRelated Views
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
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 |
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
|
|
INTERVAL |
VARCHAR2(200) |
NOT NULL |
A date function, evaluated at the start of execution, becomes next NEXT_DATE |
FAILURES |
NUMBER |
Number of times the job has started and failed since its last success | |
WHAT |
VARCHAR2(4000) |
Body of the anonymous PL/SQL block that the 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. |
