PacktLib: Mastering Oracle Scheduler in Oracle 11g Databases

Mastering Oracle Scheduler in Oracle 11g Databases

Credits

About the Author

About the Reviewers

Preface

Simple Jobs

Creating a user

Running your Jobs

Defining arguments for your jobs

Summary

Simple Chain

Jobs

Chains

Statuses

Chains and steps

Rules

Evaluation interval

Privileges

Steps to create a chain

Hands-on with chains

DB Console

Running the chain

Tricks with chains

Manipulating the running chains

Analyzing the chain

Summary

Control the Scheduler

Job creation

Job execution

Scheduler management

Logging

Summary

Managing Resources

Resource consumer group

Class

Plan

Window

Window groups

Monitoring

Problems with Resource Manager

Problems that Resource Manager solves

Summary

Getting Out of the Database

Security

Installation on Windows

Installation on Linux

Upgrading the remote job agent

Silent install of the remote job agent

Preparing the database for remote agent usage

Configuring a remote agent

Multiple agents on the same host

Credentials

Creating job—targeting Unix

Creating job—targeting Windows

Runtime observations of the remote Scheduler

Resource Manager

Summary

Events

Monitoring job events

Event-based scheduling

Summary

Debugging the Scheduler

Unix—all releases

Windows usage

Bugs

Job environment

Checks to do in the database

Summary

The Scheduler in Real Life

Statistics collection

Backups

How to use the calendar

Summary

Other Configurations

RAC

Standby databases

Summary

Scheduler GUI Tools

DB Console

Grid Control

DbVisualizer

Summary