ADM_SCHEDULER_RUNNING_JOBS

ADM_SCHEDULER_RUNNING_JOBS displays information about all DBE_SCHEDULER jobs that are being executed in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** ADM_SCHEDULER_RUNNING_JOBS columns
Name	Type	Description
owner	character varying(128)	Owner of a scheduler job.
job_name	character varying(128)	Name of a scheduler job.
job_subname	character varying(128)	Not supported. Its value is NULL.
job_style	character varying(17)	Action mode of a scheduler job. It is specified during creation. Its value can only be "REGULAR". If this parameter is not specified, the value is NULL.
detached	character varying(5)	Not supported. Its value is NULL.
session_id	numeric	ID of the session that executes a scheduler job
slave_process_id	numeric	Not supported. Its value is NULL.
slave_os_process_id	character varying(12)	ID of the process that executes a scheduler job
running_instance	numeric	Not supported. Its value is NULL.
resource_consumer_group	character varying(32)	Not supported. Its value is NULL.
elapsed_time	interval day to second(2)	Execution duration of a scheduler job
cpu_used	interval day to second(2)	Not supported. Its value is NULL.
destination_owner	character varying(261)	Not supported. Its value is NULL.
destination	character varying(261)	Target name of a scheduler job. If the value of destination is CCN, the task is a CCN job. For details, see DBE_SCHEDULER.
credential_owner	character varying(128)	Not supported. Its value is NULL.
credential_name	character varying(128)	Certificate name of a scheduler job.
log_id	numeric	Not supported. Its value is NULL.