oracle的DBA_JOBS表,ORACLE DBA_JOBS 视图

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