Record:   Prev Next
Author Rood, Ronald
Title Mastering Oracle Scheduler in Oracle 11g Databases
Imprint Olton : Packt Publishing, Limited, 2009
©2009
book jacket
Edition 1st ed
Descript 1 online resource (246 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
Note Intro -- 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
Schedule, manage, and execute jobs that automate your business processes using Oracle Scheduler with this book and eBook
Description based on publisher supplied metadata and other sources
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2020. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries
Link Print version: Rood, Ronald Mastering Oracle Scheduler in Oracle 11g Databases Olton : Packt Publishing, Limited,c2009 9781847195982
Subject Computer graphics -- Congresses.;Optical data processing -- Congresses
Electronic books
Record:   Prev Next