DBA_JOBS v17

The DBA_JOBS view provides information about all jobs in the database.

NameTypeDescription
jobINTEGERThe identifier of the job (Job ID).
log_userTEXTName of the user that submitted the job.
priv_userTEXTSame as log_user. Included only for compatibility.
schema_userTEXTName of the schema used to parse the job.
last_dateTIMESTAMP WITH TIME ZONELast date that this job executed successfully.
last_secTEXTSame as last_date.
this_dateTIMESTAMP WITH TIME ZONEDate that the job began executing.
this_secTEXTSame as this_date.
next_dateTIMESTAMP WITH TIME ZONENext date that for the job to execute.
next_secTEXTSame as next_date.
total_timeINTERVALThe execution time of this job in seconds.
brokenTEXTIf Y, no attempt is made to run this job. If N, this job attempts to execute.
intervalTEXTDetermines how often the job repeats.
failuresBIGINTNumber of times that the job failed to complete since its last successful execution.
whatTEXTThe job definition (PL/SQL code block) that runs when the job executes.
nls_envCHARACTER VARYING(4000)Always NULL. Provided only for compatibility.
misc_envBYTEAAlways NULL. Provided only for compatibility.
instanceNUMERICAlways 0. Provided only for compatibility.