Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Managing the Scheduler


While defining a schedule it is not required to launch the schedule immediately afterwards. A scheduled task can be created in a disabled status so that the user can schedule it at a later time.

All tasks leave a log that can be used to validate that the task was successful or to find out if a scheduled task failed and why. The user should know how and when to purge it so it doesn't grow too big.

Enable or disable components

The DBMS_SCHEDULER.ENABLE enables a Scheduler component, such as a program, job, window or window group, and DBMS_SCHEDULER.DISABLE disables components.

This procedure enables a job belonging to the demo Scheduler. In the previous section the TEST_MINUTELY Scheduler job was defined.

EXEC sys.dbms_scheduler.enable( '"OSCHEDULER"."TEST_MINUTELY"' );

Managing job logs

There are two important tasks to perform with the logs; these tasks are to monitor them and schedule a purge task on them. All job related activity generated by means of the dbms_scheduler...