Oracle 视图 ALL_SCHEDULER_CHAINS 官方解释,作用,如何使用详细说明
  iDU31ygkXmx7 2023年11月21日 16 0

本站中文解释

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

See Also:

  • “DBA_SCHEDULER_CHAINS”

  • “USER_SCHEDULER_CHAINS”

【版权声明】本文内容来自摩杜云社区用户原创、第三方投稿、转载,内容版权归原作者所有。本网站的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@moduyun.com

  1. 分享:
最后一次编辑于 2023年11月21日 0

暂无评论

iDU31ygkXmx7