DBA_JOBS
All jobs in the database
Columns
___________________________
JOB
Identifier of job. Neither import/export nor repeated executions change it.
LOG_USER
USER who was logged in when the job was submitted
PRIV_USER
USER whose default privileges apply to this job
SCHEMA_USER
select * from bar means select * from schema_user.bar
LAST_DATE
Date that this job last successfully executed
LAST_SEC
Same as LAST_DATE. This is when the last successful execution started.
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.
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.
TOTAL_TIME
Total wallclock time spent by the system on this job,in seconds
BROKEN
If Y,no attempt is being made to run this job. See dbms_jobq.broken(job).
INTERVAL
A date function
FAILURES
How many times has this job started and failed since its last success?
WHAT
Body of the anonymous PL/SQL block that this job executes
NLS_ENV
alter session parameters describing the NLS environment of the job
MISC_ENV
a versioned raw maintained by the kernel
INSTANCE
Instance number restricted to run the job
http://ss64.com/orad/DBA_JOBS.html