本站中文解释
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”