介绍

DBA_SCHEDULER_WINDOWS视图提供了查询当前数据库中所有调度程序窗口的信息，调度程序和job类型，都可以理解为定时执行某些任务的程序。

视图详情

字段名	字段类型	描述	译	备注
WINDOW_NAME	VARCHAR2(30)	Name of the Scheduler window	调度程序窗口的名称
RESOURCE_PLAN	VARCHAR2(30)	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	调度程序窗口的计划类型： ONCE - NAMED - CALENDAR - 用作时间表的Oracle日历表达式
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)	调度程序窗口是否启用，TRUE-已启用，FALSE-禁用
ACTIVE	VARCHAR2(5)	Indicates whether the window is open (TRUE) or not (FALSE)	调度程序窗口是否打开(运行)，TRUE-正在执行，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(240)	Comments on the window	调度程序窗口的描述