Oracle教程 2023-03-20

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

本站中文解释

Oracle 视图 ALL_SCHEDULER_CHAIN_STEPS 是用来查看 Oracle 数据库定义的 Scheduler 链的步骤的。Scheduler 链是用来组成一系列有组织的任务，它们在某个未来的时刻在特定的时间间隔内自动执行。

ALL_SCHEDULER_CHAIN_STEPS 视图的结构有以下字段：

CHAIN_NAME： Scheduler 链的名字

CHAIN_OWNER： Scheduler 链的拥有者

STEP_ORDER： Scheduler 链中定义的步骤的顺序

PROCESS_NAME：执行链步骤的调度程序

PROCESS_ORDER：执行调度程序的顺序

想要查看所有定义了的 Scheduler 链中第一步实际执行的进程，可以执行下面的 SQL 语句：

SELECT CHAIN_NAME, CHAIN_OWNER, PROCESS_NAME, PROCESS_ORDER
FROM ALL_SCHEDULER_CHAIN_STEPS
WHERE STEP_ORDER = 1;

官方英文解释

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

Related Views

DBA_SCHEDULER_CHAIN_STEPS displays information about the defined steps of all chains in the database.
USER_SCHEDULER_CHAIN_STEPS displays information about the defined steps of 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 the step is in
`CHAIN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the Scheduler chain the step is in
`STEP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the chain step
`PROGRAM_OWNER`	`VARCHAR2(392)`		Owner of the program that runs during the step
`PROGRAM_NAME`	`VARCHAR2(392)`		Name of the program that runs during the step
`EVENT_SCHEDULE_OWNER`	`VARCHAR2(392)`		Owner of the event schedule that this step waits for
`EVENT_SCHEDULE_NAME`	`VARCHAR2(392)`		Name of the event schedule that this step waits for
`EVENT_QUEUE_OWNER`	`VARCHAR2(128)`		Owner of the source queue into which the event will be raised
`EVENT_QUEUE_NAME`	`VARCHAR2(128)`		Name of the source queue into which the event will be raised
`EVENT_QUEUE_AGENT`	`VARCHAR2(523)`		Name of the AQ agent used by the user on the event source queue (for a secure queue)
`EVENT_CONDITION`	`VARCHAR2(4000)`		Boolean expression used as the subscription rule for an event on the source queue
`CREDENTIAL_OWNER`	`VARCHAR2(128)`		Owner of the credential to be used for an external step job
`CREDENTIAL_NAME`	`VARCHAR2(128)`		Name of the credential to be used for an external step job
`DESTINATION`	`VARCHAR2(261)`		Destination host on which a remote step job will run
`SKIP`	`VARCHAR2(5)`		Indicates whether the step should be skipped (`TRUE`) or not (`FALSE`)
`PAUSE`	`VARCHAR2(5)`		Indicates whether the step should be paused after running (`TRUE`) or not (`FALSE`)
`PAUSE_BEFORE`	`VARCHAR2(5)`		Indicates whether the step should be paused before running (`TRUE`) or not (`FALSE`)
`RESTART_ON_RECOVERY`	`VARCHAR2(5)`		Indicates whether the step should be restarted on database recovery (`TRUE`) or not (`FALSE`)
`RESTART_ON_FAILURE`	`VARCHAR2(5)`		Indicates whether the step should be restarted on application failure (`TRUE`) or not (`FALSE`)
`STEP_TYPE`	`VARCHAR2(21)`		Type of the step: `EVENT_SCHEDULE` `INLINE_EVENT` `SUBCHAIN` `PROGRAM`
`TIMEOUT`	`INTERVAL DAY(3) TO SECOND(0)`		Timeout for waiting on an event schedule

本站中文解释

官方英文解释

相关推荐