Oracle教程 2023-02-23

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

本站中文解释

Oracle视图ALL_SCHEDULER_CHAINS显示所有发布的调度程序链，其中指定的任务在指定顺序上调度运行。

用法：

1.查询所有当前已发布的调度程序链：
SELECT * FROM ALL_SCHEDULER_CHAINS;

2.确定指定任务是否在指定链中调度运行：
SELECT * FROM ALL_SCHEDULER_CHAINS WHERE JOB_NAME=’你的任务名’ AND CHAIN_NAME=’你的链名’;

官方英文解释

ALL_SCHEDULER_CHAINS displays information about the chains accessible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).

Related Views

DBA_SCHEDULER_CHAINS displays information about all chains in the database.
USER_SCHEDULER_CHAINS displays information about the chains 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 chain
`CHAIN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the Scheduler chain
`RULE_SET_OWNER`	`VARCHAR2(128)`		Owner of the rule set describing the dependencies
`RULE_SET_NAME`	`VARCHAR2(128)`		Name of the rule set describing the dependencies
`NUMBER_OF_RULES`	`NUMBER`		Number of rules in the chain
`NUMBER_OF_STEPS`	`NUMBER`		Number of defined steps in the chain
`ENABLED`	`VARCHAR2(5)`		Indicates whether the chain is enabled (`TRUE`) or disabled (`FALSE`)
`EVALUATION_INTERVAL`	`INTERVAL DAY(3) TO SECOND(0)`		Periodic interval at which to reevaluate rules for the chain
`USER_RULE_SET`	`VARCHAR2(5)`		Indicates whether the chain uses a user-specified rule set (`TRUE`) or not (`FALSE`)
`COMMENTS`	`VARCHAR2(4000)`		Comments on the chain

本站中文解释

官方英文解释

相关推荐