04669nam 2200685Ia 450 991045664480332120200520144314.01-282-15930-51-84719-599-79786612159305(CKB)2430000000040701(EBL)956360(OCoLC)697724350(SSID)ssj0000348707(PQKBManifestationID)12084734(PQKBTitleCode)TC0000348707(PQKBWorkID)10346033(PQKB)11757211(MiAaPQ)EBC956360(CaSebORM)9781847195982(PPN)22802837X(Au-PeEL)EBL956360(CaPaEBR)ebr10433562(CaONFJC)MIL215930(EXLCZ)99243000000004070120090827d2009 uy 0engur|n|---|||||txtccrMastering Oracle Scheduler in Oracle 11g databases[electronic resource] schedule, manage, and execute jobs that automate your business processes /Ronald Rood1st editionBirmingham, U.K. Packt Publishing Ltd.20091 online resource (240 p.)From technologies to solutionsIncludes index.1-84719-598-9 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 chainsManipulating 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 releasePatch 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; BugsJob 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 definitionStandby 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; IndexSchedule, manage, and execute jobs that automate your business processes using Oracle Scheduler with this book and eBookDatabase managementProduction schedulingData processingRelational databasesElectronic books.Database management.Production schedulingData processing.Relational databases.005.75/65Rood Ronald993558MiAaPQMiAaPQMiAaPQBOOK9910456644803321Mastering Oracle Scheduler in Oracle 11g databases2274999UNINA