Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Windows create_window

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Windows

The output from the windows.sql script confirms that the windows have been removed successfully.

SQL> @windows

WINDOW_NAME              RESOURCE_PLAN     ENABL ACTIV
------------------------ ----------------- ----- -----
WEEKEND_WINDOW                             TRUE TRUE
WEEKNIGHT_WINDOW                           TRUE FALSE

2 rows selected.

The following section will show how to group related windows together using window groups.

Window Groups

A window group is a collection of related windows, which can be assigned to the schedule_name parameter of a job instead of a schedule object. It can be created with zero, one or many windows as group members using the create_window_group procedure.

PROCEDURE create_window_group(
group_name             IN VARCHAR2,
window_list            IN VARCHAR2 DEFAULT NULL,
comments               IN VARCHAR2 DEFAULT NULL)

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

http://www.rampant-books.com/book_2005_1_scheduling.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA