Oracle教程 2023-02-23

Oracle 视图 ALL_SCHEDULER_PROGRAMS 官方解释，作用，如何使用详细说明

view

ALL_SCHEDULER_PROGRAMS视图显示了有关排程用户定义程序（UDFs）的信息。该视图可用于构建应用程序对调度程序的更高级的控制，尤其是当用户有复杂的排程程序要处理的时候。此外，此视图还可以用于监视排程程序的活动、检查执行状态以及确定排程程序中存在的错误。

要使用ALL_SCHEDULER_PROGRAMS视图，用户需要拥有SELECT权限，并且模式中需要有排程程序。用户可以使用以下SELECT语句来显示排程程序中所有可以找到的信息：

SELECT * FROM ALL_SCHEDULER_PROGRAMS;

字段描述：

OWNER – 程序拥有者的名称。
PROGRAM_NAME – 用户定义程序的名称。
PROGRAM_TYPE – 该程序的类型，可以为“STORED_PROCEDURE”、“EXECUTABLE”或“CMD_LINE”。
ENABLED – 指示当前排程程序是否被启用。

可以使用ALL_SCHEDULER_PROGRAMS视图在模式中列出所有排程程序，以及程序监视和管理活动排程程序。有关如何管理和监视排程程序的更多信息，请参考Oracle文档。

ALL_SCHEDULER_PROGRAMS displays information about the Scheduler programs accessible to the current user.

Related Views

DBA_SCHEDULER_PROGRAMS displays information about all Scheduler programs in the database.
USER_SCHEDULER_PROGRAMS displays information about the Scheduler programs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the Scheduler program
`PROGRAM_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the Scheduler program
`PROGRAM_TYPE`	`VARCHAR2(16)`		Type of the program action: `PLSQL_BLOCK` `STORED_PROCEDURE` `EXECUTABLE`
`PROGRAM_ACTION`	`VARCHAR2(4000)`		String specifying the program action
`NUMBER_OF_ARGUMENTS`	`NUMBER`		Number of arguments accepted by the program
`ENABLED`	`VARCHAR2(5)`		Indicates whether the program is enabled (`TRUE`) or disabled (`FALSE`)
`DETACHED`	`VARCHAR2(5)`		This column is for internal use
`SCHEDULE_LIMIT`	`INTERVAL DAY(3) TO SECOND(0)`		Maximum delay in running the program after the scheduled start
`PRIORITY`	`NUMBER`		Priority of the program
`WEIGHT`	`NUMBER`		Weight of the program
`MAX_RUNS`	`NUMBER`		Maximum number of runs of any job based on this program
`MAX_FAILURES`	`NUMBER`		Maximum number of failures of any job based on this program
`MAX_RUN_DURATION`	`INTERVAL DAY(3) TO SECOND(0)`		Maximum amount of time this program can run
`HAS_CONSTRAINTS`	`VARCHAR2(5)`		Indicates whether the job (not including the program of the job) is part of a resource constraint or incompatibility (`TRUE`) or not (`FALSE`)
`NLS_ENV`	`VARCHAR2(4000)`		NLS environment in which the program was created
`COMMENTS`	`VARCHAR2(4000)`		Comments on the program