Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Window Groups add_window_group_member remove_window_group_member

Phone
800-766-1884

Oracle 11g Books

Oracle training

STATSPACK Viewer

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Window Groups

Figure 2.16 shows the Scheduler Window Groups screen in the OEM 10g DB Control.

Figure 2.16 – OEM 10g DB Control: Scheduler Window Groups

Windows can be added and removed from a group using the add_window_group_member and remove_window_group_member procedures, respectively.

PROCEDURE add_window_group_member (
group_name IN VARCHAR2,
window_list IN VARCHAR2)

PROCEDURE remove_window_group_member (
group_name IN VARCHAR2,
window_list IN VARCHAR2)

The parameters associated with these procedures and their usage are as follows:

group_name - A name that uniquely identifies the window group.
window_list - A comma separated list of windows to be added or removed from the window group.

The following example creates a new window, adds it to a group and then removes it from the group.

Figure 2.17 shows the Edit Window Group screen in the OEM 10g DB Control. Windows can be added and removed from a window group using this screen.

Figure 2.17 – OEM 10g DB Control: Edit Window Group

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

Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation.
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks