Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Window Groups create_window_groups dba_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

The parameters associated with this procedure and their usage are as follows:

group_name - A name that uniquely identifies the window group.
window_list - A comma separated list of windows associated with the window group.
comments - Free text allowing the user to record additional information.

The following code creates a window group and assigns the two test windows defined in the previous section.

BEGIN
DBMS_SCHEDULER.create_window_group (
    group_name => 'test_window_group',
    window_list => 'test_window_1, test_window_2',
    comments    => 'A test window group');
END;
/

Figure 2.15 shows the Create Window Group screen in the OEM 10g DB Control.

Figure 2.15 – OEM 10g DB Control: Create Window Group

Information about window groups can be displayed using the dba_scheduler_window_groups and dba_scheduler_wingroup_members views. The following script uses both views to display a summary of window group information.

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