Mastering Oracle Scheduler in Oracle 11g databases schedule, manage, and execute jobs that automate your business processes
Schedule, manage, and execute jobs that automate your business processes using Oracle Scheduler with this book and eBook
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Birmingham, U.K. :
Packt Publishing Ltd
2009.
|
| Edition: | 1st edition |
| Series: | From technologies to solutions
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628161206719 |
Table of Contents:
- Cover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 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; Chapter 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 chainsAnalyzing the chain; Summary; Chapter 3: Control the Scheduler; Job creation; Job execution; Scheduler management; Logging; Log detail level; Log purging; Summary; Chapter 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; Chapter 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 levelPreparing 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; Chapter 6: Events; Monitoring job events; Events in chains; Event-based scheduling; Summary; Chapter 7: Debugging the Scheduler; Unix-all releases; Windows usage; Bugs
- Job environmentChecks to do in the database; Summary; Chapter 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; Summary; Chapter 9: Other Configurations; RAC; Job creation/modification; The job_class definition
- Standby databasesCreating jobs in a logical standby database; Running jobs in a logical standby database; Summary; Chapter 10: Scheduler GUI Tools; DB Console; Grid Control; DbVisualizer; Summary; Index
