ALL_SCHEDULER_WINDOWS

Previous Next JavaScript must be enabled to correctly display this content

3.67 ALL_SCHEDULER_WINDOWS

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"