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 both PG_CATALOG and SYS schema.

**Table 1** ADM_SCHEDULER_RUNNING_JOBS columns
Name	Type	Description
owner	character varying(128)	Owner of a scheduled job.
job_name	character varying(128)	Name of a scheduled job.
job_subname	character varying(128)	Not supported. Its value is NULL.
job_style	character varying(17)	Style of a scheduled job, which 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 scheduled 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 scheduled 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 scheduled 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 scheduled job.
credential_name	character varying(128)	Credential name of a scheduled job.
credential_owner	character varying(128)	Not supported. Its value is NULL.
log_id	numeric	Not supported. Its value is NULL.