1.

Record Nr.

UNINA9910456644803321

Autore

Rood Ronald

Titolo

Mastering Oracle Scheduler in Oracle 11g databases [[electronic resource] ] : schedule, manage, and execute jobs that automate your business processes / / Ronald Rood

Pubbl/distr/stampa

Birmingham, U.K., : Packt Publishing Ltd., 2009

ISBN

1-282-15930-5

1-84719-599-7

9786612159305

Edizione

[1st edition]

Descrizione fisica

1 online resource (240 p.)

Collana

From technologies to solutions

Disciplina

005.75/65

Soggetti

Database management

Production scheduling - Data processing

Relational databases

Electronic books.

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di contenuto

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

Sommario/riassunto

Schedule, manage, and execute jobs that automate your business processes using Oracle Scheduler with this book and eBook