Mastering Oracle Scheduler in Oracle 11g Databases -- Table of Contents -- Mastering Oracle Scheduler in Oracle 11g Databases -- Credits -- About the Author -- About the Reviewers -- Preface -- An overview of Oracle Scheduler -- Database background -- Scheduling events in the database -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code for the book -- Errata -- Piracy -- Questions -- 1. Simple Jobs -- Creating a user -- Running your Jobs -- PL/SQL block -- Stored procedure -- Executable -- Program -- Defining arguments for your jobs -- Metadata arguments -- Normal application arguments -- Summary -- 2. Simple Chain -- Jobs -- Chains -- Statuses -- Chains and steps -- Rules -- Evaluation interval -- Privileges -- Steps to create a chain -- Hands-on with chains -- Programs -- SHUTDOWN -- COPYFILES -- STARTUP -- Program state -- DB Console -- Chain definition -- Running the chain -- Tricks with chains -- Manipulating the running chains -- Analyzing the chain -- Summary -- 3. Control the Scheduler -- Job creation -- Job execution -- Scheduler management -- Logging -- Log detail level -- Log purging -- Summary -- 4. Managing Resources -- Resource consumer group -- Creating resource consumer groups -- Class -- Plan -- Window -- Window groups -- Monitoring -- Problems with Resource Manager -- Problems that Resource Manager solves -- Summary -- 5. Getting Out of the Database -- Security -- Installation on Windows -- Installation on Linux -- Upgrading the remote job agent -- Silent install of the remote job agent -- Base release -- Patch to the latest available level -- Preparing the database for remote agent usage -- Verifying the XDB installation -- Setting the HTTP port -- Creating remote Scheduler objects -- Setting registration password.

Configuring a remote agent -- Troubleshooting -- Multiple agents on the same host -- Credentials -- Creating job-targeting Unix -- Creating job-targeting Windows -- Runtime observations of the remote Scheduler -- Resource Manager -- Summary -- 6. Events -- Monitoring job events -- Events in chains -- Event-based scheduling -- Summary -- 7. Debugging the Scheduler -- Unix-all releases -- Windows usage -- Bugs -- Job environment -- Checks to do in the database -- Summary -- 8. The Scheduler in Real Life -- Statistics collection -- The schedule_run procedure -- The run procedure -- The statob procedure -- The drop_jobs procedure -- Generating the jobs -- Performing the analysis -- Generating the scheduled run -- Backups -- Things that can scare you -- Diving into the code -- Reading the event queue -- Scheduling for the HOT backups -- Scheduling the DARC process -- Scheduling the final BARC process -- How to use the calendar -- Tools -- How to schedule on the first day of a month -- How to schedule only on Monday -- How to schedule on the first Monday of a month -- How to schedule on the first working day of a month -- How to schedule on the first working Monday of a month -- How to schedule on the nth Monday of a month -- How to schedule on the last working day of a month -- How to schedule in the first quarter of a year -- How to schedule on the first Monday of the first quarter -- Summary -- 9. Other Configurations -- RAC -- Job creation/modification -- The job_class definition -- Standby databases -- Creating jobs in a logical standby database -- Running jobs in a logical standby database -- Summary -- 10. Scheduler GUI Tools -- DB Console -- Grid Control -- DbVisualizer -- Summary -- Index.