The DBA_JOBS view provides the information about all jobs in the database.
The DBA_JOBS view requires the superuser permissions to create the DBMS_JOB extension. If you want to use this feature, Contact us.
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 |
|
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. |