ADM_SCHEDULER_PROGRAMS

PLSQL_BLOCK: fast anonymous stored procedure.
STORED_PROCEDURE: stored procedure that is saved.
EXTERNAL_SCRIPT: external script.

ADM_SCHEDULER_PROGRAMS displays information about all programs that can be scheduled 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_PROGRAMS columns
Name	Type	Description
owner	name	Owner of a scheduler program.
program_name	text	Name of a scheduler program.
program_type	character varying(16)	Type of a scheduler program. The options are as follows: PLSQL_BLOCK: fast anonymous stored procedure. STORED_PROCEDURE: stored procedure that is saved. EXTERNAL_SCRIPT: external script.
program_action	text	Action performed by a scheduler program.
number_of_arguments	numeric	Number of scheduler program parameters.
enabled	character varying(5)	Specifies whether a scheduler program is enabled.
comments	text	Comments of a scheduler program.
detached	character varying(5)	Not supported. Its value is NULL.
schedule_limit	interval day to second(0)	Not supported. Its value is NULL.
priority	numeric	Not supported. Its value is NULL.
weight	numeric	Not supported. Its value is NULL.
max_runs	numeric	Not supported. Its value is NULL.
max_failures	numeric	Not supported. Its value is NULL.
max_run_duration	interval day to second(0)	Not supported. Its value is NULL.
has_constraints	character varying(5)	Not supported. Its value is NULL.
nls_env	character varying(4000)	Not supported. Its value is NULL.