ALL_SCHEDULER_RUNNING_JOBS

Previous Next JavaScript must be enabled to correctly display this content

3.62 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(128)`		Owner of the running Scheduler job
`JOB_NAME`	`VARCHAR2(128)`		Name of the running Scheduler job
`JOB_SUBNAME`	`VARCHAR2(128)`		Subname of the running Scheduler job (for a job running a chain step)
`JOB_STYLE`	`VARCHAR2(17)`		Job style: `REGULAR` `LIGHTWEIGHT` `IN_MEMORY_RUNTIME` `IN_MEMORY_FULL`
`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(128)`		Owner of the login credential used for this running job, if any
`CREDENTIAL_NAME`	`VARCHAR2(128)`		Name of the login credential used for this running job, if any
`LOG_ID`	`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.

See Also: