Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Enterprise Scheduling Service

• 1.1 Introduction to Administering Oracle Enterprise Scheduling Service
• 1.2 Basic Tasks for Configuring and Managing Oracle Enterprise Scheduling Service
  • 1.2.1 Set Up and Configuration
  • 1.2.2 Creating Jobs to Run
  • 1.2.3 Bundling Jobs and Refining Their Work
  • 1.2.4 Monitoring the System

2 Getting Started Managing Oracle Enterprise Scheduling Service

• 2.1 Logging into Oracle Enterprise Manager Fusion Middleware Control Console
• 2.2 Navigating to Oracle Enterprise Scheduling Service Administration Tasks
• 2.3 The Scheduling Service Home Page
• 2.4 Logging Out of Oracle Enterprise Manager Fusion Middleware Control

3 Performing Basic Administration Tasks

• 3.1 Introduction to Performing Basic Administration Tasks
• 3.2 Creating a Domain That Includes Oracle Enterprise Scheduling Service Components Using the Configuration Wizard
• 3.3 Configuring Perl to Support Process Jobs
• 3.4 Configuring Oracle Enterprise Scheduling Service
  • 3.4.1 Expanding an Oracle Enterprise Scheduling Service Cluster
  • 3.4.2 Configuring a Request Processor
  • 3.4.3 Configuring a Request Dispatcher
• 3.5 Starting and Stopping Oracle Enterprise Scheduling Service Components
  • 3.5.1 Starting and Stopping an Oracle Enterprise Scheduling Service Service Instance
  • 3.5.2 Starting and Stopping a Request Processor or Dispatcher
• 3.6 Managing Application Properties
• 3.7 Managing Application and Role Policies
  • 3.7.1 Managing Application Roles
• 3.8 Managing Oracle Enterprise Scheduling Service Web Services

4 Managing Oracle Enterprise Scheduling Service Requests

• 4.1 Introduction to Managing Oracle Enterprise Scheduling Service Job Requests
• 4.2 Managing Oracle Enterprise Scheduling Service Requests
  • 4.2.1 Submitting an Oracle Enterprise Scheduling Service Job Request
    • 4.2.1.1 Creating a Job Request
    • 4.2.1.2 Specifying a Job Request Schedule
  • 4.2.2 Searching for Oracle Enterprise Scheduling Service Job Requests
    • 4.2.2.1 Searching for a Job Request Using Simple Search
    • 4.2.2.2 Searching for a Job Request Using the Advanced Search Feature
    • 4.2.2.3 Configuring the Display of Columns in the Search Results Table
  • 4.2.3 Creating or Editing Predefined Job Schedules
  • 4.2.4 Viewing Job Request Details
  • 4.2.5 Holding and Resuming Oracle Enterprise Scheduling Service Job Requests
  • 4.2.6 Cancelling Oracle Enterprise Scheduling Service Job Requests
    • 4.2.6.1 Initiating Cancellation During Pre-Process Handler Execution
    • 4.2.6.2 Initiating Cancellation During Synchronous Java Job Execution
    • 4.2.6.3 Initiating Cancellation During Asynchronous Java Job Execution
    • 4.2.6.4 Initiating Cancellation During PL/SQL Job Execution
    • 4.2.6.5 Initiating Cancellation During Spawned Job Execution
    • 4.2.6.6 Cancelling Parent Job Requests
    • 4.2.6.7 Cancelling a Child Job Request
• 4.3 Managing Purge Policies
  • 4.3.1 Setting Up a New Purge Policy
  • 4.3.2 Physically Purging Job Requests from the Database
  • 4.3.3 Viewing Purge Policies
  • 4.3.4 Updating a Purge Policy
  • 4.3.5 Deleting a Purge Policy
• 4.4 Configuring Simple Data Security for Job Requests
  • 4.4.1 Oracle Simple Data Security Actions
  • 4.4.2 How to Create Data Security Policies for Oracle Enterprise Scheduling Service Components

5 Managing the Work of Oracle Enterprise Scheduling Service Jobs

• 5.1 Introduction to Managing the Work of Oracle Enterprise Scheduling Service Jobs
• 5.2 Managing Job Metadata
  • 5.2.1 Managing Job Definitions
    • 5.2.1.1 Viewing Job Definitions
    • 5.2.1.2 Creating a Job Definition
  • 5.2.2 Managing Job Sets
    • 5.2.2.1 Viewing Job Sets
    • 5.2.2.2 Creating or Editing a Job Set
    • 5.2.2.3 Deleting a Job Set
  • 5.2.3 Managing Incompatibilities
    • 5.2.3.1 Viewing Incompatibilities
    • 5.2.3.2 Creating or Editing an Incompatibility
    • 5.2.3.3 Deleting an Incompatibility
• 5.3 Managing Work Assignments and Workshifts
  • 5.3.1 Managing Work Assignments
    • 5.3.1.1 Creating or Editing a Work Assignment
    • 5.3.1.2 Deleting a Work Assignment
  • 5.3.2 Managing Workshifts
    • 5.3.2.1 Creating or Editing a Workshift
    • 5.3.2.2 Deleting a Workshift
  • 5.3.3 Managing Schedules
    • 5.3.3.1 Creating or Editing a Schedule
    • 5.3.3.2 Deleting a Schedule
• 5.4 Managing Metadata Security for Jobs
  • 5.4.1 Metadata Security Actions
  • 5.4.2 How to Create Metadata Policies for Oracle Enterprise Scheduling Service Resources

6 Monitoring Oracle Enterprise Scheduling Service

• 6.1 Overview of Monitoring Oracle Enterprise Scheduling Service
• 6.2 Monitoring Oracle Enterprise Scheduling Service Request Activity
  • 6.2.1 Viewing Top Ten Long Running Requests and Top Ten Ready Requests
    • 6.2.1.1 Viewing Top Ten Long Running Oracle Enterprise Scheduling Service Requests
    • 6.2.1.2 Viewing Top Ten Oracle Enterprise Scheduling Service Jobs Ready to Be Executed
  • 6.2.2 Viewing Completed Job Requests
  • 6.2.3 Viewing Job Request Response and Load
  • 6.2.4 Viewing Performance as Processing and Wait Times
• 6.3 Monitoring the Performance of a Single Oracle Enterprise Scheduling Service Instance
  • 6.3.1 Viewing a Summary of Oracle Enterprise Scheduling Service Activity
  • 6.3.2 Viewing Current Oracle Enterprise Scheduling Service Activity
  • 6.3.3 Viewing Historical Oracle Enterprise Scheduling Service Reports
  • 6.3.4 Managing Chart Sets
    • 6.3.4.1 Saving a Chart Set
    • 6.3.4.2 Deleting a Chart Set
    • 6.3.4.3 Reordering Charts
    • 6.3.4.4 Reverting to an Old Chart Set
  • 6.3.5 Selecting the Performance Time Period
• 6.4 Monitoring Key Performance Metrics for Oracle Enterprise Scheduling Service
• 6.5 Viewing General Oracle Enterprise Scheduling Service Instance Information
• 6.6 Viewing Scheduler Component Status
• 6.7 Managing Logging for Oracle Enterprise Scheduling Service
  • 6.7.1 Viewing Log Information for the Domain
  • 6.7.2 Viewing Job Request Logs
  • 6.7.3 Viewing Log Messages for Scheduled Job Requests
  • 6.7.4 Setting Oracle Enterprise Scheduling Service Log Levels
  • 6.7.5 Tracing Oracle Enterprise Scheduling Service Jobs
  • 6.7.6 Saving Job Request Logs

A High Availability for Oracle Enterprise Scheduling Service

• A.1 Introduction to High Availability for Oracle Enterprise Scheduling Service
• A.2 Oracle Enterprise Scheduling Service Concepts
  • A.2.1 Oracle Enterprise Scheduling Service Architecture
  • A.2.2 Oracle Enterprise Scheduling Service Components
  • A.2.3 Oracle Enterprise Scheduling Service Life Cycle
  • A.2.4 Oracle Enterprise Scheduling Service Life Cycle Tools
• A.3 Configuring High Availability for Oracle Enterprise Scheduling Service
  • A.3.1 Oracle Enterprise Scheduling Service Configuration and Deployment Artifacts
  • A.3.2 Oracle Enterprise Scheduling Service Logging
  • A.3.3 Oracle Enterprise Scheduling Service Cluster Architecture
  • A.3.4 Failover Requirements
    • A.3.4.1 Request Processor Failover
    • A.3.4.2 External Component Failover
  • A.3.5 Scalability
  • A.3.6 Backup and Recovery
  • A.3.7 Load Balancing
• A.4 Managing an Oracle Enterprise Scheduling Service Cluster
  • A.4.1 Starting and Stopping the Cluster
  • A.4.2 Propagating Configuration Changes to the Cluster
  • A.4.3 Deploying Applications to the Cluster
  • A.4.4 Failures and Expected Behavior
    • A.4.4.1 Retries
    • A.4.4.2 Death Detection and Restart
    • A.4.4.3 Oracle Java Transaction API Migration and Oracle Java Message Service

B Troubleshooting Oracle Enterprise Scheduling Service

• B.1 Introduction to Troubleshooting Oracle Enterprise Scheduling Service
• B.2 Getting Started with Troubleshooting Oracle Enterprise Scheduling Service Jobs
  • B.2.1 Troubleshooting Asynchronous Scheduled Jobs
    • B.2.1.1 Troubleshooting Asynchronous Java Jobs
    • B.2.1.2 Troubleshooting Asynchronous PL/SQL Jobs
  • B.2.2 Troubleshooting Process Jobs
  • B.2.3 Steps for Manual Recovery
    • B.2.3.1 Handling Synchronous Java Jobs Requiring Manual Recovery
    • B.2.3.2 Handling Stuck Asynchronous Jobs Requiring Manual Recovery
  • B.2.4 Job Diagnostics
• B.3 Getting Started with Troubleshooting an Oracle Enterprise Scheduling Service Cluster
  • B.3.1 Finding Performance and Scalability Issues
  • B.3.2 Using a Shared Database
  • B.3.3 Tuning Oracle Enterprise Scheduling Service System Performance
    • B.3.3.1 Tuning Clusters
    • B.3.3.2 Processor Bindings
    • B.3.3.3 Using Job Incompatibility to Manage Performance
    • B.3.3.4 Tuning Oracle Enterprise Scheduling Service for Optimal Performance
    • B.3.3.5 Tuning Dead Database Connections
• B.4 Problems and Solutions
  • B.4.1 Job Remains in WAIT State
  • B.4.2 Synchronous Job Continues in RUNNING State for Too Long
  • B.4.3 Asynchronous Jobs Remain in RUNNING State and Do Not Complete
  • B.4.4 Asynchronous Java SOA Job Remains In RUNNING State
  • B.4.5 Asynchronous Java Oracle ADF Business Components Job Remains In RUNNING State
  • B.4.6 Asynchronous PL/SQL Job Remains in RUNNING State
  • B.4.7 Job Does Not Execute at Scheduled Time
  • B.4.8 Asynchronous Java Job Requires Manual-Error Recovery
  • B.4.9 Spawned (Process Type) Job Requires Manual Error Recovery
  • B.4.10 Job Remains in CANCELLING State
  • B.4.11 Performance and Scalability Goes Down When Two Very Database Intensive Jobs Run at the Same Time
  • B.4.12 Newly Added Server Is Not Being Utilized or Running Inappropriate Jobs
  • B.4.13 Oracle Enterprise Scheduling Service Run-Time System Is Throwing Errors
  • B.4.14 Oracle Enterprise Scheduling Service Is Running Out Of Database Connections
  • B.4.15 Job Queue Full Due to a Hanging Job
• B.5 Using My Oracle Support for Additional Troubleshooting Information

Index