ALL_JOBS v11

The ALL_JOBS view provides information about all jobs that reside in the database.

NameTypeDescription
jobINTEGERThe identifier of the job (Job ID).
log_userTEXTThe name of the user that submitted the job.
priv_userTEXTSame as log_user. Included for compatibility only.
schema_userTEXTThe name of the schema used to parse the job.
last_dateTIMESTAMP WITH TIME ZONEThe last date that this job executed successfully.
last_secTEXTSame as last_date.
this_dateTIMESTAMP WITH TIME ZONEThe date that the job began executing.
this_secTEXTSame as this_date.
next_dateTIMESTAMP WITH TIME ZONEThe next date that this job will be executed.
next_secTEXTSame as next_date.
total_timeINTERVALThe execution time of this job (in seconds).
brokenTEXTIf Y, no attempt will be made to run this job. If N, this job will attempt to execute.
intervalTEXTDetermines how often the job will repeat.
failuresBIGINTThe number of times that the job has failed to complete since it’s last successful execution.
whatTEXTThe job definition (PL/SQL code block) that runs when the job executes.
nls_envCHARACTER VARYING(4000)Always NULL. Provided for compatibility only.
misc_envBYTEAAlways NULL. Provided for compatibility only.
instanceNUMERICAlways 0. Provided for compatibility only.