Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_JOBS

ALL_JOBS describes all jobs in the database that are accessible to the current user.

Related Views

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 SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, the Oracle Database 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 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.