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

Examples

SET LINESIZE 80
column job format 9999
column log_user format A10
column next_date format A9
column next_sec format A8
column interval format A15
column what format A26

-- scheduled jobs
select job, log_user, next_date, next_sec, interval, what
from dba_jobs;

--completed/failed jobs
select job, log_user, last_date, last_sec, broken,failures
from dba_jobs;

Related:

DBA_SCHEDULER_JOBS


© Copyright SS64.com 1999-2014
Some rights reserved