ADM_SCHEDULER_PROGRAMS

PLSQL_BLOCK: anonymous block of a 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 both PG_CATALOG and SYS schema.

**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 the scheduler. The options are as follows: PLSQL_BLOCK: anonymous block of a 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.