Oracle教程 2023-02-27

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

本站中文解释

ALL_SCHEDULER_WINDOWS 视图显示了用户可以创建和使用的窗口。

Oracle 数据库调度器窗口允许用户配置作业和程序在不同的时间和日期来运行，而且这些作业和程序可以根据窗口的定义来重复运行。

要使用 ALL_SCHEDULER_WINDOWS 视图，可以使用以下语句查看用户所有的窗口：

SELECT * FROM ALL_SCHEDULER_WINDOWS;

要创建一个新窗口，可以使用DBMS_SCHEDULER.CREATE_WINDOWPLSQL 存储过程，如下所示：

BEGIN
DBMS_SCHEDULER.CREATE_WINDOW (
window_name => ‘my_window’,
repeat_interval=> ‘freq=daily’,
duration => NULL,
start_time => ’07:00am’,
end_time => ’11:00pm’
);
END;
/

官方英文解释

ALL_SCHEDULER_WINDOWS displays information about the Scheduler windows accessible to the current user.

Related View

DBA_SCHEDULER_WINDOWS displays information about all Scheduler windows in the database.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the Scheduler window
`WINDOW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the Scheduler window
`RESOURCE_PLAN`	`VARCHAR2(128)`		Resource plan associated with the window
`SCHEDULE_OWNER`	`VARCHAR2(4000)`		Owner of the schedule of the window
`SCHEDULE_NAME`	`VARCHAR2(4000)`		Name of the schedule of the window
`SCHEDULE_TYPE`	`VARCHAR2(8)`		Type of the schedule of the window: `ONCE` – Repeat interval is NULL `NAMED` – Named schedule `CALENDAR` – Oracle calendaring expression used as schedule
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Start date of the window (for an inline schedule)
`REPEAT_INTERVAL`	`VARCHAR2(4000)`		Calendar string for the window (for an inline schedule)
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Date after which the window will no longer open (for an inline schedule)
`DURATION`	`INTERVAL DAY(3) TO SECOND(0)`		Duration of the window
`WINDOW_PRIORITY`	`VARCHAR2(4)`		Priority of the job relative to other windows: `HIGH` `LOW`
`NEXT_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Next date on which the window is scheduled to start
`LAST_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Last date on which the window opened
`ENABLED`	`VARCHAR2(5)`		Indicates whether the window is enabled (`TRUE`) or disabled (`FALSE`)
`ACTIVE`	`VARCHAR2(5)`		Indicates whether the window is open (`TRUE`) or not (`FALSE`)
`MANUAL_OPEN_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		Open time of the window if it was manually opened, else NULL
`MANUAL_DURATION`	`INTERVAL DAY(3) TO SECOND(0)`		Duration of the window if it was manually opened, else NULL
`COMMENTS`	`VARCHAR2(4000)`		Comments on the window

本站中文解释

官方英文解释

相关推荐