Mastering Oracle Scheduler in Oracle 11g Databases. Schedule, manage, and execute jobs in Oracle 11g Databases that automate your business processes u

Mastering Oracle Scheduler in Oracle 11g Databases. Schedule, manage, and execute jobs in Oracle 11g Databases that automate your business processes u - Opis

Scheduler (DBMS_SCHEDULER) is included in Oracle Database and is a tool for the automation, management, and control of jobs. It enables users to schedule jobs running inside the database such as PL/SQL procedures or PL/SQL blocks, as well as jobs running outside the database like shell scripts. Scheduler ensures that jobs are run on time, automates business processes, and optimizes the use of available resources.You just need to specify a fixed date and time and Scheduler will do the rest. What if you don't know the precise time to execute your job? Nothing to worry about, you can specify an event upon which you want your job to be done and Scheduler will execute your job at the appropriate time. Although scheduling sounds quite easy, it requires programming skills and knowledge to set up such a powerful, intelligent scheduler for your project.This book is your practical guide to DBMS_SCHEDULER for setting up platform-independent schedules that automate the execution of time-based or event-based job processes. It will show you how to automate business processes, and help you manage and monitor those jobs efficiently and effectively. It explains how Scheduler can be used to achieve the tasks you need to make happen in the real world. With a little understanding of how the Scheduler can be used and what kind of control it gives, you will be able to recognize the real power that many known enterprise-class schedulers ñ with serious price tags ñ cannot compete with.You will see how running a specific program can be made dependent on the successful running of certain other (...) więcej programs, and how to separate various tasks using the built-in security mechanisms. You will learn to manage resources to balance the load on your system, and gain increased database performance. Spis treści:
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 jobtargeting Unix
Creating jobtargeting 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
Unixall 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 O autorze: Ronald Rood has been an IT professional for over 20 years. His roots are in the Bull gcos8 mainframes where he played with assembly language until Oracle and UNIX came across his path. He eagerly joined the Oracle community and became a skilled innovating DBA and trouble shooter. Ronald's real power is in the combination of the rich UNIX world and Oracle. There is no such thing as a problem that can not be solved; it just might take a little time. Next to C, PRO*C, lots of scripting languages and – of course – PL/SQL, he also speaks Dutch, English, German, and some French. In his private time that he shares with his family with two children he likes to take an occasional dive (from the sky), fly radio controlled models, ride recumbent, and work as a volunteer for a local Water Scouts group. Currently Ronald is one of the Ciber oracle consultants in The Netherlands and cooperates in many projects for many large companies. Before writing this book Ronald wrote oracle related articles for the Dutch oracle user group magazine. On his blog you can find some short articles about various items, mostly oracle related. Ronald Rood has been interviewed by Oracle about Oracle Scheduler. Listen to it here here. mniej