1/16
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
Scripting on this page enhances content navigation, but does not change the content in any way.