ALL_SCHEDULER_RUNNING_JOBS

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

Related Views

DBA_SCHEDULER_RUNNING_JOBS displays information about all running Scheduler jobs in the database.
USER_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the running Scheduler job
`JOB_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the running Scheduler job
`JOB_SUBNAME`	`VARCHAR2(30)`		Subname of the running Scheduler job
`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`	`NUMBER`		Scheduler job CPU time consumed, if available