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

See Also:

“DBA_SCHEDULER_WINDOWS”


数据运维技术 » Oracle 视图 ALL_SCHEDULER_WINDOWS 官方解释,作用,如何使用详细说明