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_CHAINSdisplays information about all chains in the database.USER_SCHEDULER_CHAINSdisplays information about the chains owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Owner of the Scheduler chain |
|
|
| Name of the Scheduler chain |
|
| Owner of the rule set describing the dependencies | |
|
| Name of the rule set describing the dependencies | |
|
| Number of rules in the chain | |
|
| Number of defined steps in the chain | |
|
| Indicates whether the chain is enabled ( | |
|
| Periodic interval at which to reevaluate rules for the chain | |
|
| Indicates whether the chain uses a user-specified rule set ( | |
|
| Comments on the chain |
See Also:
“DBA_SCHEDULER_CHAINS”
“USER_SCHEDULER_CHAINS”
编辑：568数据
标签：程序,英文,视图,中文,顺序