Skip Headers
Oracle® Fusion Applications Developer's Guide for Oracle Enterprise Scheduler
11
g
Release 1 (11.1.2)
Part Number E10142-02
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction to Oracle Enterprise Scheduler
1.1
About Oracle Enterprise Scheduler
1.2
Oracle Enterprise Scheduler Overview for Application Developers
1.2.1
Introduction to Working with Oracle Enterprise Scheduler at Design-time
1.2.2
Introduction to Working with Oracle Enterprise Scheduler at Runtime
1.2.3
Oracle Enterprise Scheduler Job Requests
1.2.4
Overview of Integration Steps
1.3
Fixed-Rate Scheduling with Oracle Enterprise Scheduler
2
Verifying the Oracle Enterprise Scheduler Installation
2.1
Introduction to Verifying the Oracle Enterprise Scheduler Installation
2.2
How to Verify the Oracle Enterprise Scheduler Installation Using a Browser
2.3
How to Programmatically Verify the Oracle Enterprise Scheduler Installation
2.4
What Happens When You Verify the Oracle Enterprise Scheduler Installation
2.5
What Happens at Runtime: How the Oracle Enterprise Scheduler Installation is Verified
3
Use Case Oracle Enterprise Scheduler Sample Application
3.1
Introduction to the Scheduler Sample Application
3.2
Creating the Application and Projects for Scheduler Sample Application
3.2.1
How to Create the EssDemoApp Application
3.2.2
How to Create a Project in the Scheduler Sample Application
3.2.3
How to Set Project Properties for Enterprise Scheduler
3.3
Creating a Java Implementation Class for the Sample Application
3.3.1
How to Create a Java Class Using the Executable Interface
3.3.2
What Happens When You Create a Java Class That Implements the Executable Interface
3.3.3
What You Need to Know About the Executable Interface
3.4
Adding Application Code to Submit Oracle Enterprise Scheduler Job Requests
3.4.1
How to Add Required Libraries to Project
3.4.2
How to Create the EssDemo Servlet
3.5
Creating Metadata for Scheduler Sample Application
3.5.1
How to Create a Job Type for Java
3.5.2
How to Create a Job Definition for Java
3.6
Assembling the Scheduler Sample Application
3.6.1
How to Assemble the EJB Jar Files for Scheduler Sample Application
3.6.2
How to Assemble the MAR File for User Metadata
3.6.3
How to Assemble the EAR File for Scheduler Sample Application
3.6.4
Add oracle.ess Library Weblogic Application Descriptor
3.7
Deploying and Running the Scheduler Sample Application
3.7.1
How to Deploy the EssDemoApp Application
3.7.2
How to Run the Scheduler Sample Application
3.7.3
How to Purge Jobs in the Scheduler Sample Application
3.8
Troubleshooting the Oracle Enterprise Scheduler Sample Application
3.8.1
How to Create the Oracle Enterprise Scheduler Database Schema
3.8.2
How to Drop the Oracle Enterprise Scheduler Runtime Schema
3.9
Using Submitting and Hosting Split Applications
3.9.1
How to Create the Backend Hosting Application for Scheduler
3.9.1.1
Creating the Backend Hosting Application
3.9.1.2
Configuring Security for the Backend Hosting Application
3.9.1.3
Defining the Deployment Descriptors for the Backend Hosting Application
3.9.1.4
Creating a Java Implementation Class in the Backend Hosting Application
3.9.1.5
Creating Metadata for the Backend Hosting Application
3.9.1.6
Assembling the Backend Hosting Application for Oracle Enterprise Scheduler
3.9.1.7
Deploying the Backend Hosting Application
3.9.2
How to Create the Frontend Submitter Application for Oracle Enterprise Scheduler
3.9.2.1
Creating the Frontend Submitter Application
3.9.2.2
Configuring the ejb-jar.xml File for the Frontend Submitter Application
3.9.2.3
Creating the SuperWeb Project
3.9.2.4
Configuring Security for the Frontend Submitter Application
3.9.2.5
Creating the HTTP Servlet for the Frontend Submitter Application
3.9.2.6
Editing the web.xml File for the Frontend Submitter Application
3.9.2.7
Editing the weblogic-application.xml file for the Frontend Submitter Application
3.9.2.8
Editing the adf-config file for the Frontend Submitter Application
3.9.2.9
Assembling the Frontend Submitter Application for Oracle Enterprise Scheduler
3.9.2.10
Deploying the Backend Hosting Application
4
Using the Metadata Service
4.1
Introduction to Using the Metadata Service
4.1.1
Introduction to Metadata Service Namespaces
4.1.2
Introduction to Metadata Service Operations
4.1.3
Introduction to Metadata Service Transactions
4.2
Accessing the Metadata Service
4.2.1
How to Access the Metadata Service with a Stateless Session EJB
4.3
Accessing the Metadata Service with Oracle JDeveloper
4.4
Querying Metadata Using the Metadata Service
4.4.1
How to Create a Filter
4.4.2
How to Query Metadata Objects
5
Using Parameters and System Properties
5.1
Introduction to Using Parameters and System Properties
5.1.1
What You Need to Know About Parameter and System Property Naming
5.1.2
What You Need to Know About Parameter Conflict Resolution and Parameter Materialization
5.1.2.1
What You Need to Know About Job Definition Parameter Materialization
5.1.2.2
What You Need to Know About Job Set Level Parameter Materialization
5.2
Using Parameters with the Metadata Service
5.2.1
How to Use Parameters and System Properties in Metadata Objects
5.3
Using Parameters with the Runtime Service
5.3.1
How to Use Parameters with the Runtime Service
5.3.2
How to Use Parameters with a Step ID for Job Set Steps
5.4
Using System Properties
6
Creating and Using PL/SQL Jobs
6.1
Introduction to Using PL/SQL Stored Procedure Job Definitions
6.2
Creating a PL/SQL Stored Procedure for Oracle Enterprise Scheduler
6.2.1
How to Define a PL/SQL Stored Procedure with the Correct Signature
6.2.2
Handling Runtime Exceptions in an Oracle Enterprise Scheduler PL/SQL Stored Procedure
6.2.3
How to Access Job Request Information In PL/SQL Stored Procedures
6.2.4
What You Need to Know When You Define a PL/SQL Stored Procedure
6.3
Performing Oracle Database Tasks for PL/SQL Stored Procedures
6.3.1
How to Grant PL/SQL Stored Procedure Permissions
6.3.2
What You Need to Know About Granting PL/SQL Stored Procedure Permissions
6.4
Creating and Storing Job Definitions for PL/SQL Job Types
6.4.1
How to Create a PL/SQL Job Type
6.4.2
How to Create and Store a Job Definition for PL/SQL Job Type
6.4.3
Using a PL/SQL Stored Procedure with an Oracle Enterprise Scheduler Application
7
Creating and Using Process Jobs
7.1
Introduction to Creating Process Job Definitions
7.2
Creating and Storing Job Definitions for Process Job Types
7.2.1
How to Create and Store a Process Job Type
7.2.2
How to Create and Store a Process Type Job Definition
7.3
Using a Perl Agent Handler for Process Jobs
8
Defining and Using Schedules
8.1
Introduction to Schedules
8.2
Defining a Recurrence
8.2.1
How to Define a Recurrence with a Recurrence Fields Helper
8.2.2
How to Define a Recurrence with an iCalendar RFC 2445 Specification
8.2.3
What You Need to Know When You Use a Recurrence Fields Helper
8.2.4
What You Need to Know When You Use an iCalendar Expression
8.3
Defining an Explicit Date
8.3.1
How to Define an Explicit Date
8.3.2
What You Need to Know About Explicit Dates
8.4
Defining and Storing Exclusions
8.4.1
How to Define an Exclusion
8.4.2
How to Create an Exclusions Definition
8.5
Defining and Storing Schedules
8.5.1
How to Define and Store a Schedule
8.5.2
What Happens When You Define and Store a Schedule
8.5.3
What You Need to Know About Handling Time Zones with Schedules
8.6
Identifying Job Requests That Use a Particular Schedule
8.7
Updating and Deleting Schedules
9
Working with Extensions to Oracle Enterprise Scheduler
9.1
Introduction to Oracle Enterprise Scheduler Extensions
9.2
Standards and Guidelines
9.3
Creating and Implementing a Scheduled Job in JDeveloper
9.3.1
How to Create and Implement a Scheduled Job in JDeveloper
9.3.2
What Happens at Runtime: How a Scheduled Job Is Created and Implemented in JDeveloper
9.4
Creating a Job Definition
9.4.1
How to Create a Job Definition
9.4.2
How to Define File Groups for a Job
9.4.3
What Happens When You Create a Job Definition
9.4.4
What Happens at Runtime: How Job Definitions Are Created
9.5
Configuring a Spawned Job Environment
9.5.1
How to Create an Environment File for Spawned Jobs
9.5.2
How to Configure an Oracle Wallet for Spawned Jobs
9.5.3
What Happens When You Configure a Spawned Job Environment
9.6
Implementing a PL/SQL Scheduled Job
9.6.1
Standards and Guidelines for Implementing a PL/SQL Scheduled Job
9.6.2
How to Define Metadata for a PL/SQL Scheduled Job
9.6.3
How to Implement a PL/SQL Scheduled Job
9.6.4
What Happens When You Implement a PL/SQL Job
9.6.5
What Happens at Runtime: How a PL/SQL Job is Implemented
9.7
Implementing a SQL*Plus Scheduled Job
9.7.1
Standards and Guidelines for Implementing a SQL*Plus Scheduled Job
9.7.2
How to Implement a SQL*Plus Job
9.7.3
How to Use the SQL*Plus Runtime API
9.7.4
What Happens When You Implement a SQL*Plus Job
9.7.5
What Happens at Runtime: How a SQL*Plus Job Is Implemented
9.8
Implementing a SQL*Loader Scheduled Job
9.8.1
How to Implement a SQL*Loader Scheduled Job
9.8.2
What Happens When You Implement a SQL*Loader Scheduled Job
9.9
Implementing a Perl Scheduled Job
9.9.1
How to Implement a Perl Scheduled Job
9.9.2
What Happens When You Implement a Perl Scheduled Job
9.10
Implementing a C Scheduled Job
9.10.1
How to Define Metadata for a C Scheduled Job
9.10.2
How to Implement a C Scheduled Job
9.10.3
Scheduled C Job API
9.10.4
How to Test a C Scheduled Job
9.10.5
What Happens When You Implement a C Scheduled Job
9.10.6
What Happens at Runtime: How a C Scheduled Job Is Implemented
9.11
Implementing a Host Script Scheduled Job
9.12
Implementing a Java Scheduled Job
9.12.1
How to Define Metadata for a Scheduled Java Job
9.12.2
How to Use the Java Runtime API
9.12.3
How to Cancel a Scheduled Java Job
9.12.4
What Happens at Runtime: How a Java Scheduled Job Is Implemented
9.13
Elevating Access Privileges for a Scheduled Job
9.13.1
How to Elevate Access Privileges for a Scheduled Job
9.13.2
How Access Privileges Are Elevated for a Scheduled Job
9.13.3
What Happens When Access Privileges Are Elevated for a Scheduled Job
9.14
Creating an Oracle ADF User Interface for Submitting Job Requests
9.14.1
How to Create an Oracle ADF User Interface for Submitting Job Requests
9.14.2
How to Add a Custom Task Flow to an Oracle ADF User Interface for Submitting Job Requests
9.14.3
How to Enable Support for Context-Sensitive Parameters in an Oracle ADF User Interface for Submitting Job Requests
9.14.4
How to Save and Schedule a Job Request Using an Oracle ADF UI
9.14.5
How to Submit a Job Using a Saved Schedule in an Oracle ADF UI
9.14.6
How to Notify Users or Groups of the Status of Executed Jobs
9.14.7
What Happens When You Create an Oracle ADF User Interface for Submitting Job Requests
9.14.8
What Happens at Runtime: How an Oracle ADF User Interface for Submitting Job Requests Is Created
9.15
Submitting Job Requests Using the Request Submission API
9.16
Defining Oracle Business Intelligence Publisher Post-Processing Actions for a Scheduled Job
9.16.1
How to Define Oracle BI Publisher Post-Processing for a Scheduled Job
9.16.2
How to Define Oracle BI Publisher Post-Processing Actions for a Scheduled PL/SQL Job
9.16.3
What Happens When You Define Oracle BI Publisher Post-Processing Actions for a Scheduled Job
9.16.4
What Happens at Runtime: How Oracle BI Publisher Post-Processing Actions are Defined for a Scheduled Job
9.16.5
Invoking Post-Processing Actions Programmatically
9.17
Monitoring Scheduled Job Requests Using an Oracle ADF UI
9.17.1
How to Monitor Scheduled Job Requests
9.17.2
How to Embed a Table of Search Results as a Region on a Page
9.17.3
How to Log Scheduled Job Requests in an Oracle ADF UI
9.17.4
How to Troubleshoot an Oracle ADF UI Used to Monitor Scheduled Job Requests
9.18
Using a Task Flow Template for Submitting Scheduled Requests through an Oracle ADF UI
9.18.1
How to Use a Task Flow Template for Submitting Scheduled Requests through an Oracle ADF UI
9.18.2
How to Extend the Task Flow Template for Submitting Scheduled Requests through an Oracle ADF UI
9.18.3
What Happens When you Use a Task Flow Template for Submitting Scheduled Requests through an Oracle ADF UI
9.18.4
What Happens at Runtime: How a Task Flow Template Is Used to Submit Scheduled Requests through an Oracle ADF UI
9.19
Securing Oracle ADF UIs
9.20
Integrating Scheduled Job Logging with Fusion Applications
9.21
Logging Scheduled Jobs
9.21.1
Using the Request Log
9.21.2
Using the Output File
9.21.3
Debugging and Error Logging
10
Using the Oracle Enterprise Scheduler Web Service
10.1
Introduction to the Oracle Enterprise Scheduler Web Service
10.2
Developing and Using ESSWebservice Applications
10.2.1
How to Develop and Use an ESSWebservice Java EE Application
10.2.2
How to Develop and Use an ESSWebservice SOA Application with BPEL
10.2.3
Setting Web Service Addressing Headers for getCompletionStatus() Operation
10.2.4
Limitations for ESSWebservice
10.2.5
ESSWebservice Implementation
10.3
ESSWebservice WSDL File
10.4
Use Case Using Scheduler ESSWebservice from a BPEL Process
10.5
Creating the ESSWebService Application and a SOA Project
10.5.1
How to Create the ESSWebService Application and Project
10.6
Creating the ESSWebService Reference
10.6.1
How to Add the ESSWebService Partner Link
10.7
Adding the BPEL Process to Call the ESSWebService
10.7.1
How to Add a BPEL Process to Call the ESSWebService
10.7.2
Copy Types Into BPEL Process Schema
10.7.3
How to Invoke the ESSWebService submitRequest Operation
10.7.4
Assign Required Input Parameters for Request Submission
10.7.5
Invoke the getCompletionStatus Operation
10.7.6
Assign Input to the getCompletionStatus Operation
10.7.7
Receive the Job Completion Status
10.7.8
Return Result to Client
10.8
Using Additional ESSWebService Operations
10.8.1
How to Invoke the ESSWebService submitRecurringRequest Operation
10.8.2
How to Invoke the ESSWebService setSubmitArgs Operation
10.8.3
How to Invoke the ESSWebService addPPActions Operation
10.8.4
How to Invoke the ESSWebService setStepsArgs Operation
10.9
Securing the Oracle Enterprise Scheduler Web Service
10.9.1
How to Secure the Oracle Enterprise Scheduler Web Service
10.9.2
What Happens When You Secure the Oracle Enterprise Scheduler Web Service
10.10
Deploying and Testing the Project
10.10.1
How to Test the Web Service
11
Defining and Using Job Sets
11.1
Introduction to Defining and Using Job Sets
11.2
Defining Job Sets
11.2.1
How to Define a Job Set
11.2.2
How to Define Serial Job Set Steps
11.2.3
How to Define Parallel Job Set Steps
11.2.4
What Happens When You Define a Job Set
11.2.5
What You Need to Know About Serial Job Sets
11.2.6
What You Need to Know About Job Set Parameters and System Properties
11.2.7
What Happens at Runtime for Job Set State Priorities and State Transitions
11.3
Cross Application Job Sets
11.3.1
Overview of Cross Application Job Sets
11.3.2
Requirements for Cross Application Job Sets
11.4
Using Input and Output Forwarding
11.4.1
Supporting Input and Output Forwarding in Job Sets
12
Defining and Using a Job Incompatibility
12.1
Introduction to Using a Job Incompatibility
12.1.1
Job Self Incompatibility
12.2
Defining Incompatibility with Oracle JDeveloper
12.2.1
How to Define a Global Incompatibility
12.2.2
How to Define a Domain Incompatibility
12.3
What Happens at Runtime to Handle Job Incompatibility
12.3.1
What Happens to Subrequests with an Incompatible Parent Request
12.3.2
What Happens to the Scope of Request Incompatibility
13
Using the Runtime Service
13.1
Introduction to the Runtime Service
13.2
Accessing the Runtime Service
13.2.1
How to Access the Runtime Service and Obtain a Runtime Service Handle
13.3
Submitting Job Requests
13.3.1
How to Submit a Request to the Runtime Service
13.3.2
What You Should Know About Default System Properties When You Submit a Request
13.3.3
What You Should Know About Metadata When You Submit a Request
13.4
Managing Job Requests
13.4.1
How to Get Job Request Information with getRequestDetail
13.4.2
How to Change Job Request State
13.4.3
How to Update Job Request Priority and Job Request Parameters
13.5
Querying Job Requests
13.6
Submitting Ad Hoc Job Requests
13.6.1
How to Create an Ad Hoc Request
13.6.2
What Happens When You Create an Ad Hoc Request
13.6.3
What You Need to Know About Ad Hoc Requests
14
Using Subrequests
14.1
Introduction to Using Subrequests
14.2
Sample Subrequest
14.3
Creating and Managing Subrequests
14.3.1
How to Submit Subrequests
14.3.2
How to Cancel Subrequests
14.3.3
How to Hold Subrequests
14.3.4
How to Delete Subrequests
14.3.5
How to Submit Multiple Subrequests
14.3.6
How to Manage Paused Subrequests
14.3.6.1
Indicating Paused Status
14.3.6.2
Storing the Paused State for a Parent Request
14.3.7
How Subrequests Are Processed
14.3.8
How to Identify Subrequests
14.3.9
How to Manage Subrequests and Incompatibility
14.4
Creating a Java Procedure that Submits a Subrequest
14.5
Creating a PL/SQL Procedure that Submits a Subrequest
15
Working with Asynchronous Java Jobs
15.1
Introduction to Working with Asynchronous Java Jobs
15.2
Creating an Asynchronous Java Job
15.2.1
Implementing the Asynchronous Java Job Asynchronous Interface
15.2.2
Asynchronous Java Job execute() Method
15.2.3
Invoking a Remote Job from an Asynchronous Java Job
15.2.4
Calling Back to Oracle Enterprise Scheduler with Status Updates
15.2.5
Updating the Asynchronous Java Job
15.2.6
Notifying Oracle Enterprise Scheduler When an Asynchronous Job Completes
15.2.6.1
Using the Web Service to Notify When an Asynchronous Job Completes
15.2.6.2
Using EJB to Notify When an Asynchronous Job Completes
15.2.7
Asynchronous Java Job AsyncCancellable Interface
15.2.8
Sample Asynchronous Java Job Invoking a BPEL Process Through Event Delivery Network
15.2.8.1
Sample BPEL Process Design Time with Oracle Enterprise Scheduler
15.3
A Use Case Illustrating the Implementation of a BPEL Process as an Asynchronous Job
15.3.1
Introduction to the Recommended Design Pattern
15.3.2
Potential Approaches
15.3.3
Use Case Summary
15.4
How to Implement BPEL with an Asynchronous Job
15.4.1
Use Case: Add Oracle JDeveloper Libraries
15.4.2
Use Case: Create the Asynchronous Job Definition
15.4.3
Use Case: Design the Event Payload Schema and Event Definition Files
15.4.4
Programmatically Raise a Business Event from the Asynchronous Job Methods
15.4.5
Design the SOA Composite with Meditator and BPEL
15.4.6
Add Fault Handling and Correlated onMessage Branch for Error and Cancel Job
15.4.6.1
Create Correlation Set and Define Initiate Activity
15.4.6.2
Create the onMessage Branch with Use of Correlation Set
15.4.6.3
Create the Fault Branch
15.4.6.4
Populate the onMessage and Fault Branch
15.4.7
Validating the Deployment
15.4.8
Troubleshooting the Use Case
15.5
Handling Time Outs and Recovery for Asynchronous Jobs
15.5.1
Asynchronous Request Time Outs
15.5.1.1
Setting the TIme Out Value
15.5.1.2
Discovering the Asynchronous Job Requests that Have Timed Out
15.5.1.3
Completing Asynchronous Requests without a Time Out
15.5.1.4
What Happens When an Asynchronous Job Request Times Out
15.5.2
Handling Asynchronous Jobs Marked for Manual Recovery
15.5.3
Using RecoverRequest to Manually Recover a Job Request
15.6
Oracle Enterprise Scheduler Interfaces and Classes
16
Oracle Enterprise Scheduler Security
16.1
Introduction to Oracle Enterprise Scheduler Security
16.1.1
Oracle Enterprise Scheduler Metadata Access Control
16.1.2
Oracle Enterprise Scheduler Job Execution Security
16.2
Configuring Metadata Security for Oracle Enterprise Scheduler
16.2.1
How to Enable Application Security with Oracle ADF Security Wizard
16.2.2
How to Define Principals for Security
16.2.3
How to Create Grants with Oracle Enterprise Scheduler Metadata Pages
16.2.4
How to Create Grants with Oracle ADF Security Wizard
16.2.5
About MetadataPermission APIs
16.2.6
What Happens When You Configure Metadata Security
16.3
Configuring Web Service Security for Oracle Enterprise Scheduler
16.4
Configuring PL/SQL Job Security for Oracle Enterprise Scheduler
16.5
Elevating Privileges for Oracle Enterprise Scheduler Jobs
16.6
Configuring a Single Policy Stripe in Oracle Enterprise Scheduler
16.6.1
How to Configure a Single Policy Stripe in Oracle Enterprise Scheduler
16.6.2
What Happens When You Configure a Single Policy Stripe
16.6.3
What Happens at Runtime
16.7
Configuring Oracle Fusion Data Security for Job Requests
16.7.1
Oracle Fusion Data Security Artifacts
16.7.2
How to Apply Oracle Fusion Data Security Policies
16.7.3
How to Create Functional and Data Security Policies for Oracle Enterprise Scheduler Components
17
Managing Business and System Errors
17.1
Introduction to Managing Business and System Errors
17.2
Indicating Errors
17.2.1
How to Indicate a Business Error
17.2.2
How to Indicate a System Error
17.3
Configuring Retries for a Job Request
17.3.1
How to Configure Retries for a Job Request
17.3.2
What Happens at Run Time: How a Job Request Is Retried
17.3.3
What You Should Know about Configuring Retries for a Job Request
17.4
Finding and Diagnosing Job Requests in Error State
17.4.1
Retrieving the State of a Job Request
17.4.2
Finding Job Requests with Business Errors
17.4.3
Determining the Number of Times a Job Request Has Been Retried
Scripting on this page enhances content navigation, but does not change the content in any way.