USER_JOBS v15
The USER_JOBS view provides information about all jobs owned by the current user.
| Name | Type | Description |
|---|---|---|
job | INTEGER | Identifier of the job (Job ID). |
log_user | TEXT | Name of the user that submitted the job. |
priv_user | TEXT | Same as log_user. Included only for compatibility. |
schema_user | TEXT | Name of the schema used to parse the job. |
last_date | TIMESTAMP WITH TIME ZONE | Last date that this job executed successfully. |
last_sec | TEXT | Same as last_date. |
this_date | TIMESTAMP WITH TIME ZONE | Date that the job began executing. |
this_sec | TEXT | Same as this_date. |
next_date | TIMESTAMP WITH TIME ZONE | Next date that this job will execute. |
next_sec | TEXT | Same as next_date. |
total_time | INTERVAL | Execution time of this job (in seconds). |
broken | TEXT | If Y, no attempt is made to run this job. If N, this job attempts to execute. |
interval | TEXT | Determines how often the job repeats. |
failures | BIGINT | Number of times that the job has failed to complete since it’s last successful execution. |
what | TEXT | Job definition (PL/SQL code block) that runs when the job executes. |
nls_env | CHARACTER VARYING(4000) | Always NULL. Provided only for compatibility. |
misc_env | BYTEA | Always NULL. Provided only for compatibility. |
instance | NUMERIC | Always 0. Provided only for compatibility. |