OBIEE 10G/11G - BI Scheduler

Obi Edition


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:
  • 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.



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


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:


Obiee11g Deployment Scheduler Database


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


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 - Linux OEL 5 x86 Installation version

Open the Set the JavaHome parameter to the point to the new JDK location. For example, . tail Oracle BI Java Host start-up details: /usr/local/OracleBIData/web/log/javahost.out.log Oracle BI Java...
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...
Card Puncher Data Processing
Weblogic - (System|Non-java) components (Managed Services)

“opmnctl status“, this will show you status of all the OBIEE core services “opmnctl startall” or “opmnctl stopall” run “opmnctl startproc ias-component= ”the FMW console

Share this page:
Follow us:
Task Runner