OBIEE 10G/11G - BI Scheduler

Obi Edition

About

Oracle BI Scheduler is a server application that:

  • manages and schedules jobs
  • provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler.)

Type of Jobs

Oracle BI Scheduler supports two kinds of jobs:

Scripted jobs

Scripted jobs are set up and submitted using the Job Manager feature of the Oracle Business Intelligence Server Administration Tool. For example, a scripted job could periodically load Oracle BI Server usage statistics into a back-end database. For scripted jobs, Oracle BI Scheduler communicates with Oracle BI Server. Oracle BI Scheduler supports two published Java interfaces and two scripting languages.

  • Supported Java interfaces:
    • SchedulerJavaExtension.java
    • SchedulerJobInfo.java
  • Supported script languages (Windows Platform only):
    • VBScript
    • JScript

Unscripted jobs, called (iBots|Agent)

(iBots|Agent) delivers reports and alerts to end users. (iBots|Agent) are configured and submitted for execution using the web client Oracle Business Intelligence Delivers which is a module of BI Presentation Service.

Configuration

10G

OBIEE 10G/11G - BI Scheduler Configuration (for Delivers)

11G

You use the Repository Creation Utility (RCU) to create Oracle BI Scheduler database schemas and tables.

You can also create tables in Oracle BI Scheduler's schema for use with other major commercial databases, by running the SQL scripts in the following directory:

\orainst\bifoundation\OracleBISchedulerComponent\coreapplication_obisch1\schema\

Obiee11g Deployment Scheduler Database

Metadata

Table Name Table Description
S_NQ_JOB This table is used by Scheduler to store information about scheduled jobs
S_NQ_INSTANCE The S_NQ_INSTANCE table stores information about scheduled job instances
S_NQ_ERR_MSG This table stores error messages for Scheduler job instances that do not complete successfully.
S_NQ_JOB_PARAM This table holds information about Scheduler job parameters for scheduled jobs

Documentation/Reference





Discover More
Obiee Relationships Between Oracle Bi Infrastructure Components
OBIEE - Architecture

The Oracle Business Intelligence components consist of: Oracle Business Intelligence Presentation Services The Oracle Business Intelligence Presentation Services provides the framework and interface...
Obiee11g Deployment Presentation Parameters
OBIEE - Instanceconfig.xml (Configuration Presentation Services)

On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler The instanceconfig.xml...
Obi Edition
OBIEE - Java Host

The Oracle Business Intelligence Javahost provides services to BI Presentation Services for Style and Skin, Charts, Gauges and PDFs. The services are provided based on request-response model. BI Javahost...
Obi Edition
OBIEE - SASchInvoke (command line Triggering of Oracle BI Scheduler Jobs)

Third-Party Triggering of Oracle BI Scheduler Jobs Third-Party Triggering of Oracle BI Scheduler Jobs
Obi Edition
OBIEE 10G/11G - (Ibot|Agent)

IBot (10g) or Agents (11g) deliver targeted analytics to users based on a combination of schedule and trigger event. Delivery can be by a variety of routes, for example to Dashboard Alerts or to e-mail....
Oracle Bi Scheduler Error 1
OBIEE 10G/11G - BI Scheduler Configuration (for Delivers)

This article go through all the minimal steps that you must perform to configure BI Scheduler. credential linkpresentation servicedeliversscheduler To go in the configuration windows : open...
Obiee Scheduler Configuration Mail
OBIEE 10G/11G - How to configure the Mail server of Scheduler/Delivers

This article talk the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as : the sender address the smtp server ...
Obi Edition
OBIEE 11G - BIPlatform Schema

The Business Intelligence Platform schema (BIPlatform) is a metadata repository such as MDS. The BIPlatform schema is created with the help of RCU. Prefix Software ANNOT For annotations CACLMGR...



Share this page:
Follow us:
Task Runner