Updated on 2024-06-03 GMT+08:00

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. Set it to NULL.

job_style

character varying(17)

Action style of a scheduler job

detached

character varying(5)

Not supported. Set it to NULL.

session_id

numeric

ID of the session that executes a scheduler job

slave_process_id

numeric

Not supported. Set it to NULL.

slave_os_process_id

character varying(12)

ID of the process that executes a scheduler job

running_instance

numeric

Not supported. Set it to NULL.

resource_consumer_group

character varying(32)

Not supported. Set it to NULL.

elapsed_time

interval day to second(2)

Execution duration of a scheduler job

cpu_used

interval day to second(2)

Not supported. Set it to NULL.

destination_owner

character varying(261)

Not supported. Set it to NULL.

destination

character varying(261)

Target name of a scheduler job

credential_owner

character varying(128)

Not supported. Set it to NULL.

credential_name

character varying(128)

Certificate name of a scheduler job.

log_id

numeric

Not supported. Set it to NULL.