Oracle PL/SQL for DBAs

Name

CREATE_WINDOW

Synopsis

This program creates a named window, which can be used as a schedule for a job. The program is overloaded into two versions, both procedures.

Procedure—Version 1 (named schedule)

Creates a named window. The schedule of the window (i.e., the information on how often the window is to be repeated) is specified as a named schedule, which must have been defined earlier.

Parameter name	Datatype	Description
window_name	VARCHAR2	Name of the window. Must be unique in the database.
resource_plan	VARCHAR2	Resource Manager plan under which this window will be placed. You must specify this parameter, and you must supply a valid Resource Manager plan.
schedule_name	VARCHAR2	Named schedule this window will follow.
duration	INTERVAL DAY TO SECOND	How long this window will stay open.
window_priority	VARCHAR2	Priority of the window. Valid values are LOW and HIGH; default is LOW. This parameter is only relevant if two windows overlap. The priority determines which window will close to make room for the other.
comments	VARCHAR2	Comments on the window.

Procedure—Version 2 (inline schedule)

Identical to Version 1, but the schedule is specified as an inline calendar string.

Parameter name	Datatype	Description
window_name	VARCHAR2	Name of the window. Must be unique in the database.
resource_plan	VARCHAR2	Resource Manager plan under which this window will be placed. You must specify this parameter, and you must supply a valid Resource Manager plan.
start_date ...