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

Parameter Type Description
job INTEGER The identifier of a job (Job ID).
log_user TEXT The name of the user that submitted the job.
priv_user TEXT The same as log_user. This parameter is supported for compatibility only.
schema_user TEXT The name of the schema used to parse the job.
last_date TIMESTAMP WITH TIME ZONE The last date when this job was executed with the expected result returned.
last_sec TEXT The same as last_date.
this_date TIMESTAMP WITH TIME ZONE The date when the system starts to execute the job.
this_sec TEXT The same as this_date.
next_date TIMESTAMP WITH TIME ZONE The next date when this job will be executed.
next_sec TEXT The same as next_date.
total_time INTERVAL The period in which the job is executed. Unit: seconds.
broken TEXT
  • Y: indicates that no attempt will be made to run this job.
  • N: indicates that attempts will be made to run this job.
interval TEXT The interval at which the job is repeated.
failures BIGINT The number of times that the job has failed since the last successful execution.
what TEXT The job definition that runs when the job executes. The job definition appears as a PL/SQL code block.
nls_env CHARACTER VARYING(4000) The value is NULL. This parameter is supported for compatibility only.
misc_env BYTEA The value is NULL. This parameter is supported for compatibility only.
instance NUMERIC The value is 0. This parameter is supported for compatibility only.