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

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Window Groups

window_groups.sql

-- *************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial purpose,
-- contact rtp AT rampant.cc
-- *************************************************

prompt
prompt WINDOW GROUPS
prompt --------------

select
   window_group_name,
   enabled,
   number_of_windowS
from
   dba_scheduler_window_groups
;

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

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