| |
 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Windows
PROCEDURE create_window (
window_name IN VARCHAR2,
resource_plan IN VARCHAR2,
start_date IN TIMESTAMP WITH
TIME ZONE DEFAULT NULL,
repeat_interval IN VARCHAR2,
end_date IN TIMESTAMP WITH
TIME ZONE DEFAULT NULL,
duration IN INTERVAL DAY TO
SECOND,
window_priority IN
VARCHAR2 DEFAULT 'LOW',
comments IN
VARCHAR2 DEFAULT NULL)
The parameters associated with these procedures
and their usage are as follows:
-
window_name - A name that
uniquely identifies the window.
-
resource_plan - The
resource plan associated with the window. When the window opens,
the system switches to use the associated resource plan. When the
window closes, the system switches back to the previous resource
plan.
-
schedule_name - The name of
the schedule associated with the window. If this is specified, the
start_date, repeat_interval and end_date must be NULL.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
