Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Installing Siebel Analytics Software in the Windows Environment > Process of Creating and Configuring Scheduler Tables (Stand-Alone on Windows) >

Creating Databases and Tables for the Siebel Analytics Scheduler

---

There is a one-to-one relationship between the relational database and the Scheduler. Therefore, the following conditions must be met:

• The Scheduler needs to be configured to use a database, and the database must be available for use, before the Scheduler service will start.
• Do not configure multiple Siebel Analytics Scheduler services to use a single database.

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

NOTE:  Before you create a database and tables, you must have an administrative sign-on account.

To create a database and tables for use by the Scheduler

1. Make sure that you have a valid administrative 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).

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

Bookshelf Home | Contents | Index | Search | PDF