ALL_JOBS v11
The ALL_JOBS view provides information about all jobs that reside in the database.
| Name | Type | Description |
|---|---|---|
job | INTEGER | The identifier of the job (Job ID). |
log_user | TEXT | The name of the user that submitted the job. |
priv_user | TEXT | Same as log_user. Included 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 that this job executed successfully. |
last_sec | TEXT | Same as last_date. |
this_date | TIMESTAMP WITH TIME ZONE | The date that the job began executing. |
this_sec | TEXT | Same as this_date. |
next_date | TIMESTAMP WITH TIME ZONE | The next date that this job will be executed. |
next_sec | TEXT | Same as next_date. |
total_time | INTERVAL | The execution time of this job (in seconds). |
broken | TEXT | If Y, no attempt will be made to run this job. If N, this job will attempt to execute. |
interval | TEXT | Determines how often the job will repeat. |
failures | BIGINT | The number of times that the job has failed to complete since it’s last successful execution. |
what | TEXT | The job definition (PL/SQL code block) that runs when the job executes. |
nls_env | CHARACTER VARYING(4000) | Always NULL. Provided for compatibility only. |
misc_env | BYTEA | Always NULL. Provided for compatibility only. |
instance | NUMERIC | Always 0. Provided for compatibility only. |