Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring Oracle Business Intelligence Scheduler >

Creating Oracle BI Scheduler Databases and Tables

This task is part of the Process of Configuring Oracle BI Scheduler.

You can either use an existing database or create a new database in which to store the tables.

The following procedure shows how to create a generic database and tables.

To create a database and tables for use by Oracle BI Scheduler

1. Make sure that you have a valid database administrator account to create a database and tables.
2. Create the database, or use an existing database.
3. Create the Scheduler tables by executing SAJOBS.xxx.sql (where xxx is the database type).

   Use the appropriate procedure for your back-end database, as shown in Creating Oracle BI Scheduler Database and Tables for Specific Databases.

4. If you are using usage statistics, create the table in SAACCT.xxx.sql.