Table: USER_JOBS
All jobs owned by this user
| Column Name | Description |
|---|---|
| BROKEN | If Y, no attempt is being made to run this job. See dbms_jobq.broken(job). |
| FAILURES | How many times has this job started and failed since its last success? |
| INSTANCE | Instance number restricted to run the job |
| INTERVAL | A date function, evaluated at the start of execution, becomes next NEXT_DATE |
| JOB | Identifier of job. Neither import/export nor repeated executions change it. |
| LAST_DATE | Date that this job last successfully executed |
| LAST_SEC | Same as LAST_DATE. This is when the last successful execution started. |
| LOG_USER | USER who was logged in when the job was submitted |
| MISC_ENV | a versioned raw maintained by the kernel, for other session parameters |
| NEXT_DATE | Date that this job will next be executed |
| NEXT_SEC | Same as NEXT_DATE. The job becomes due for execution at this time. |
| NLS_ENV | alter session parameters describing the NLS environment of the job |
| PRIV_USER | USER whose default privileges apply to this job |
| SCHEMA_USER | select * from bar means select * from schema_user.bar |
| THIS_DATE | Date that this job started executing (usually null if not executing) |
| THIS_SEC | Same as THIS_DATE. This is when the last successful execution started. |
| TOTAL_TIME | Total wallclock time spent by the system on this job, in seconds |
| WHAT | Body of the anonymous PL/SQL block that this job executes |