Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 165 of 452


DBA_JOBS_RUNNING

DBA_JOBS_RUNNING lists all jobs in the database that are currently running.

Column  Datatype  NULL  Description 

SID 

NUMBER 

 

Identifier of process that is executing the job. See "V$LOCK"

JOB  

NUMBER 

 

Identifier of job. This job is currently executing. 

FAILURES  

NUMBER 

 

Number of times this job started and failed since its last success 

LAST_DATE 

DATE 

 

Date that this job last successfully executed 

LAST_SEC  

VARCHAR2(8) 

 

Same as LAST_DATE. This is when the last successful execution started. 

THIS_DATE  

DATE 

 

Date that this job started executing 

THIS_SEC  

VARCHAR2(8) 

 

Same as THIS_DATE. This is when the last successful execution started. 

INSTANCE 

NUMBER 

 

Indicates which instance can execute or is executing the job; the default is 0 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index