Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_JOBS

Object Details
Object Name: CDB_JOBS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All jobs in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB NUMBER
Yes Identifier of job. Neither import/export nor repeated executions change it.
LOG_USER VARCHAR2 (128) Yes USER who was logged in when the job was submitted
PRIV_USER VARCHAR2 (128) Yes USER whose default privileges apply to this job
SCHEMA_USER VARCHAR2 (128) Yes select * from bar means select * from schema_user.bar
LAST_DATE DATE

Date that 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
Yes Date that this job will next be executed
NEXT_SEC VARCHAR2 (8)
Same as NEXT_DATE. The job becomes due for execution at this time.
TOTAL_TIME NUMBER

Total wallclock time spent by the system on this job, in seconds
BROKEN VARCHAR2 (1)
If Y, no attempt is being made to run this job. See dbms_jobq.broken(job).
INTERVAL VARCHAR2 (200) Yes A date function, evaluated at the start of execution, becomes next NEXT_DATE
FAILURES NUMBER

How many times has this job 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)
alter session parameters describing the NLS environment of the job
MISC_ENV RAW (32)
a versioned raw maintained by the kernel, for other session parameters
INSTANCE NUMBER

Instance number restricted to run the job
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT JOB
,      LOG_USER
,      PRIV_USER
,      SCHEMA_USER
,      LAST_DATE
,      LAST_SEC
,      THIS_DATE
,      THIS_SEC
,      NEXT_DATE
,      NEXT_SEC
,      TOTAL_TIME
,      BROKEN
,      INTERVAL
,      FAILURES
,      WHAT
,      NLS_ENV
,      MISC_ENV
,      INSTANCE
,      CON_ID
FROM SYS.CDB_JOBS;

Dependencies

[top of page]

SYS.CDB_JOBS does not reference any database object

SYS.CDB_JOBS is referenced by following:

SchemaPUBLIC
SynonymCDB_JOBS