BIP 10G/11G - Scheduler (Quartz) Configuration

About

BIP Scheduler configuration.

A database user is required to hold the scheduler metadata. It must have the privileges “connect and resource”.

Schema

Objects

List of the tables

Table Name (10g|11g)
QRTZ_BLOB_TRIGGERS
QRTZ_CALENDARS
QRTZ_CRON_TRIGGERS
QRTZ_FIRED_TRIGGERS
QRTZ_JOB_DETAILS
QRTZ_JOB_LISTENERS
QRTZ_LOCKS
QRTZ_PAUSED_TRIGGER_GRPS
QRTZ_SCHEDULER_STATE
QRTZ_SIMPLE_TRIGGERS
QRTZ_TRIGGERS
QRTZ_TRIGGER_LISTENERS
XMLP_APPINFO Only 11g
XMLP_SCHED_DATA Only 11g
XMLP_SCHED_DELIVERY Only 11g
XMLP_SCHED_JOB
XMLP_SCHED_OUTPUT
XMLP_SCHED_SUBSCRIPTION Only 10g

Installation and configuration

11g

The BIP scheduler configuration is automatically made during the initial OBIEE installation and the scheduler schema is in the BIPLATFORM schema.

10g

  • Create a database user to hold the tables
sqlplus sys/[email protected] as sysdba;
create user BIP_QUARTZ identied by BIP_QUARTZ quota unlimited on users;
grant connect, ressouce to BIP_QUARTZ;
  • In the admin page, you can find the link “System Maintenance / Scheduler Configuration” to configure the Scheduler. Enter this parameters.
Database Type Oracle
Connection String jdbc:oracle:thin:@host_of_database:1521:sid_of_database
Username Password BIP_QUARTZ/BIP_QUARTZ
Database Driver Class oracle.jdbc.driver.OracleDriver

After you fill all the parameters, test the connection with the “Test Connection Button”.

If you have a successfull message, click on the “Install Schema” button to install the schema. You must see this successful message after a few seconds :

Schema installed successfully. The scheduler settings have been saved.

To complete, click the “Apply Bouton”.

Documentation / Reference


Powered by ComboStrap