Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Window Groups dba_scheduler_wingroup

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Window Groups

select
   window_group_name,
   window_name
from
   dba_scheduler_wingroup_members
;

The output from the window_groups.sql script shows that the window group was created successfully.

SQL> @window_groups

WINDOW GROUPS
-------------

WINDOW_GROUP_NAME              ENABL NUMBER_OF_WINDOWS'
------------------------------ ----- -----------------
MAINTENANCE_WINDOW_GROUP       TRUE                  2
TEST_WINDOW_GROUP              TRUE                  2

2 rows selected.

WINDOW GROUP MEMBERS
--------------------

WINDOW_GROUP_NAME              WINDOW_NAME
------------------------------ ------------------------------
MAINTENANCE_WINDOW_GROUP       WEEKEND_WINDOW
MAINTENANCE_WINDOW_GROUP       WEEKNIGHT_WINDOW
TEST_WINDOW_GROUP              TEST_WINDOW_1
TEST_WINDOW_GROUP              TEST_WINDOW_2
4 rows selected.

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