BIP Scheduler configuration.
A database user is required to hold the scheduler metadata. It must have the privileges “connect and resource”.
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 |
The BIP scheduler configuration is automatically made during the initial OBIEE installation and the scheduler schema is in the BIPLATFORM schema.
sqlplus sys/sys_password@database as sysdba;
create user BIP_QUARTZ identied by BIP_QUARTZ quota unlimited on users;
grant connect, ressouce to BIP_QUARTZ;
| 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”.