DBA_JOBS v17
The DBA_JOBS
view provides information about all jobs in the database.
Name | Type | Description |
---|---|---|
job | INTEGER | The 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 for the job to execute. |
next_sec | TEXT | Same as next_date . |
total_time | INTERVAL | The 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 failed to complete since its 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 only for compatibility. |
misc_env | BYTEA | Always NULL . Provided only for compatibility. |
instance | NUMERIC | Always 0 . Provided only for compatibility. |