Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide

1 Introduction to Oracle Enterprise Scheduler

• 1.1 Introduction to Administering Oracle Enterprise Scheduler
• 1.2 Basic Tasks for Configuring and Managing Oracle Enterprise Scheduler
  • 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 Scheduler

• 2.1 Logging into Oracle Enterprise Manager Fusion Middleware Control Console
• 2.2 Navigating to Oracle Enterprise Scheduler 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 Scheduler Components Using the Configuration Wizard
• 3.3 Configuring Perl to Support Process Jobs
• 3.4 Configuring Oracle Enterprise Scheduler
  • 3.4.1 Expanding an Oracle Enterprise Scheduler Cluster
  • 3.4.2 Configuring a Request Processor
  • 3.4.3 Configuring a Request Dispatcher
• 3.5 Searching for Configuration Changes to Oracle Enterprise Scheduler in Cloud Control
• 3.6 Starting and Stopping Oracle Enterprise Scheduler Components
  • 3.6.1 Starting and Stopping an Oracle Enterprise Scheduler Service Instance
  • 3.6.2 Starting and Stopping a Request Processor or Dispatcher
• 3.7 Managing Application Properties
• 3.8 Managing Application and Role Policies
  • 3.8.1 Managing Application Roles
• 3.9 Managing Oracle Enterprise Scheduler Web Services

4 Managing Oracle Enterprise Scheduler Requests

• 4.1 Introduction to Managing Oracle Enterprise Scheduler Job Requests
• 4.2 Managing Oracle Enterprise Scheduler Requests
  • 4.2.1 Submitting an Oracle Enterprise Scheduler 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 Scheduler 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 Scheduler Job Requests
  • 4.2.6 Cancelling Oracle Enterprise Scheduler 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 Scheduler Components

5 Managing the Work of Oracle Enterprise Scheduler Jobs

• 5.1 Introduction to Managing the Work of Oracle Enterprise Scheduler Jobs
• 5.2 Managing Job Metadata
  • 5.2.1 Managing Job Definitions
    • 5.2.1.1 Viewing Job Definitions
    • 5.2.1.2 Creating or Editing a Job Definition
    • 5.2.1.3 Deleting 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 Scheduler Resources

6 Monitoring Oracle Enterprise Scheduler

• 6.1 Overview of Monitoring Oracle Enterprise Scheduler
• 6.2 Monitoring Oracle Enterprise Scheduler 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 Scheduler Requests
    • 6.2.1.2 Viewing Top Ten Oracle Enterprise Scheduler 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 Scheduler Instance
  • 6.3.1 Viewing a Summary of Oracle Enterprise Scheduler Activity
  • 6.3.2 Viewing Current Oracle Enterprise Scheduler Activity
  • 6.3.3 Viewing Historical Oracle Enterprise Scheduler 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 Scheduler
• 6.5 Viewing General Oracle Enterprise Scheduler Instance Information
• 6.6 Viewing Scheduler Component Status
• 6.7 Managing Logging for Oracle Enterprise Scheduler
  • 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 Scheduler Log Levels
  • 6.7.5 Tracing Oracle Enterprise Scheduler Jobs
  • 6.7.6 Saving Job Request Logs
• 6.8 Managing Alerts for Oracle Enterprise Scheduler in Cloud Control
  • 6.8.1 Configuring Metric Alerts for Oracle Enterprise Scheduler in Cloud Control
  • 6.8.2 Viewing Alerts for Oracle Enterprise Scheduler in Cloud Control
• 6.9 Auditing Administrative Actions
  • 6.9.1 Getting the List of Auditable Events
  • 6.9.2 Specifying Which Events Get Logged
  • 6.9.3 Viewing Event Audit Data

A High Availability for Oracle Enterprise Scheduler

• A.1 Introduction to High Availability for Oracle Enterprise Scheduler
• A.2 Oracle Enterprise Scheduler Concepts
  • A.2.1 Oracle Enterprise Scheduler Architecture
  • A.2.2 Oracle Enterprise Scheduler Components
  • A.2.3 Oracle Enterprise Scheduler Life Cycle
  • A.2.4 Oracle Enterprise Scheduler Life Cycle Tools
• A.3 Configuring High Availability for Oracle Enterprise Scheduler
  • A.3.1 Oracle Enterprise Scheduler Configuration and Deployment Artifacts
  • A.3.2 Oracle Enterprise Scheduler Logging
  • A.3.3 Oracle Enterprise Scheduler 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 Scheduler 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 Scheduler

• B.1 Introduction to Troubleshooting Oracle Enterprise Scheduler
• B.2 Getting Started with Troubleshooting Oracle Enterprise Scheduler 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 Scheduler Cluster
  • B.3.1 Finding Performance and Scalability Issues
  • B.3.2 Using a Shared Database
  • B.3.3 Tuning Oracle Enterprise Scheduler 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 Scheduler 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 Scheduler Run-Time System Is Throwing Errors
  • B.4.14 Oracle Enterprise Scheduler 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

C Audit Reference for Oracle Enterprise Scheduler

• C.1 About Custom and Standard Audit Reports
• C.2 Audit Events in Oracle Enterprise Scheduler