Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_SCHEDULER_RUNNING_JOBS

ALL_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the running Scheduler job
JOB_NAME VARCHAR2(30)   Name of the running Scheduler job
JOB_SUBNAME VARCHAR2(30)   Subname of the running Scheduler job (for a job running a chain step)
JOB_STYLE VARCHAR2(11)   Job style:
  • REGULAR

  • LIGHTWEIGHT

DETACHED VARCHAR2(5)   Indicates whether the detached attribute is set for the job (TRUE) or not (FALSE). If the detached attribute is set, then the job will remain running even after the job action has completed.
SESSION_ID NUMBER   Identifier of the session running the Scheduler job
SLAVE_PROCESS_ID NUMBER   Process number of the slave process running the Scheduler job
SLAVE_OS_PROCESS_ID VARCHAR2(12)   Process number of the operating system slave process running the scheduler job
RUNNING_INSTANCE NUMBER   Database instance number of the slave process running the Scheduler job
RESOURCE_CONSUMER_GROUP VARCHAR2(32)   Resource consumer group of the session in which the Scheduler job is running
ELAPSED_TIME INTERVAL DAY(3) TO SECOND(2)   Elapsed time since the Scheduler job was started
CPU_USED INTERVAL DAY(3) TO SECOND(2)   CPU time consumed by the running Scheduler job, if available
DESTINATION_OWNER VARCHAR2(128)   Owner of the destination object (if used), else NULL
DESTINATION VARCHAR2(128)   Destination that this job is running on
CREDENTIAL_OWNER VARCHAR2(30)   Owner of the login credential used for this running job, if any
CREDENTIAL_NAME VARCHAR2(30)   Name of the login credential used for this running job, if any
LOG_IDFoot 1  NUMBER   Log ID used for this running job. This column maps to the LOG_ID column of the *_SCHEDULER_JOB_LOG and *_SCHEDULER_JOB_RUN_DETAILS views.

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).