Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_JOBS

All jobs owned by this user

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

Related:



Simon Sheppard
SS64.com