Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Windows Scheduler Windows open_window close

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Windows

job_user@db10g> @windows

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

4 rows selected.

Figure 2.14 shows the Scheduler Windows screen in the OEM 10g DB Control.

Figure 2.14 – OEM 10g DB Control: Scheduler Windows

The server normally controls the opening and closing of windows, but they also can be opened and closed manually using the open_window and close_window procedures.

PROCEDURE open_window (
window_name             IN VARCHAR2,
duration                IN INTERVAL DAY TO SECOND,
force                   IN BOOLEAN DEFAULT FALSE)

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