Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents and Other Resources
• System Requirements and Certification
• Conventions

New Features for Scheduling Jobs for Oracle Business Intelligence

• New Features for Oracle BI EE 11g Release 1 (11.1.1.7)
• New Features for Oracle BI EE 11g Release 1 (11.1.1.6)
• New Features for Oracle BI EE 11g Release 1 (11.1.1.5)
• New Features for Oracle BI EE 11g Release 1 (11.1.1.3)

1 Introducing Oracle BI Scheduler

• 1.1 What is Oracle BI Scheduler?
• 1.2 About Oracle BI Scheduler Server Components
• 1.3 About Agent Support in Oracle BI Scheduler
• 1.4 About Database Support in Oracle BI Scheduler
• 1.5 About Oracle BI Scheduler Schemas
• 1.6 Topics of Interest in Other Guides

2 Configuration Tasks for Oracle BI Scheduler

• 2.1 Creating an Oracle BI Scheduler Database and Tables Using RCU
• 2.2 Configuring a Database for the Oracle BI Scheduler
  • 2.2.1 Using Fusion Middleware Control to Configure a Database for the Oracle BI Scheduler
  • 2.2.2 Configuring a System DSN entry for SQL Server Databases
• 2.3 Configuring Oracle BI Scheduler Instances in a Clustered Environment
• 2.4 Changing Oracle BI Scheduler Table Names

3 Using Oracle BI Scheduler Job Manager

• 3.1 Opening Job Manager
• 3.2 Adding Oracle BI Scheduler Jobs in Job Manager
• 3.3 Modifying Oracle BI Scheduler Jobs in the Job Manager
• 3.4 About Adding Agent Jobs
• 3.5 Modifying Agents in Job Manager
• 3.6 Re-Running a Job Instance
• 3.7 Managing Oracle BI Scheduler Job Instances
  • 3.7.1 Viewing or Refreshing Oracle BI Scheduler Job Instances
  • 3.7.2 Cancelling Oracle BI Scheduler Job Instances
  • 3.7.3 Purging Oracle BI Scheduler Job Instances
    • 3.7.3.1 Using the Job Manager Instances List
    • 3.7.3.2 Using the Job Manager Purge Instances Window

4 Programming BI Scheduler VBScript and JScript Jobs

• 4.1 Configuring Custom Script Properties for Oracle BI Scheduler
• 4.2 Creating a Custom Script Example - Cache Clearance
• 4.3 Configuring Custom Script Properties for Oracle BI Delivers
• 4.4 Creating a Custom Script Example - Copy Results to the File System
• 4.5 Oracle BI Scheduler Read-Only Script Object Properties
• 4.6 Oracle BI Scheduler Read/Write Script Object Properties
• 4.7 Oracle BI Scheduler Script-Defined Constants
  • 4.7.1 Severity Constants
  • 4.7.2 DayEnum Constants
  • 4.7.3 DayOfWeekEnum Constants
  • 4.7.4 JobFlagsEnum Constants
  • 4.7.5 MonthEnum Constants
  • 4.7.6 OccurrenceEnum Constants
• 4.8 Oracle BI Scheduler Script Object Methods and Events
  • 4.8.1 CreateArray Method
  • 4.8.2 DeregisterCancelCommand Method
  • 4.8.3 GetConfigurationValue Method
  • 4.8.4 GetTempFileName Method
  • 4.8.5 LaunchProcess Method
  • 4.8.6 RegisterCancelCommand Method
  • 4.8.7 ScheduleJobDaily Method
  • 4.8.8 ScheduleJobMonthlyDate Method
  • 4.8.9 ScheduleJobMonthlyDOW Method
  • 4.8.10 ScheduleJobNow Method
  • 4.8.11 ScheduleJobOnce Method
  • 4.8.12 ScheduleJobWeekly Method
  • 4.8.13 OnError Event
• 4.9 Troubleshooting JScript and VBScript Job Failures

5 Programming BI Scheduler Java Jobs

• 5.1 Using Oracle BI Scheduler Java Jobs
  • 5.1.1 Adding and Configuring Custom Java Jobs in Job Manager
  • 5.1.2 Example: Creating a Java Program for Agents
  • 5.1.3 Example: Configuring a Java Program
• 5.2 Oracle BI Scheduler Java Jobs
• 5.3 Adding Java Jobs for Oracle BI Scheduler
• 5.4 Oracle BI Scheduler Custom Java Program Package
• 5.5 SchedulerJavaExtension Interface
• 5.6 SchedulerJobInfo Interface
• 5.7 SchedulerJobException Class
• 5.8 Oracle BI Scheduler Java Extension Example

6 Oracle BI Scheduler Job Manager Menus

• 6.1 About the Job Manager
• 6.2 Toolbar Menus in Job Manager
  • 6.2.1 File Menu in Job Manager
  • 6.2.2 Service Management Menu in Job Manager
  • 6.2.3 Jobs Menu in Job Manager
  • 6.2.4 Instances Menu in Job Manager
  • 6.2.5 Instance Properties in Job Manager
• 6.3 General Oracle BI Scheduler Job Properties
• 6.4 Job Action Properties Available in Job Manager
• 6.5 Job Triggers in Job Manager
  • 6.5.1 Single-Run Triggers
  • 6.5.2 Recurrent Triggers
    • 6.5.2.1 Recurrent Trigger Types

A Setting Up the SA System Subject Area

• A.1 About the SA System Subject Area
  • A.1.1 About Group and Application Role Resolution
• A.2 Setting Up the Data Source for the SA System Subject Area
• A.3 Importing SA System Data Into the Repository
• A.4 Setting Configuration Options for the SA System Subject Area
  • A.4.1 Managing the Case of Login Names for the SA System Subject Area

Glossary

Index