Bookshelf Home | Contents | Index | PDF     

Siebel Analytics Installation and Configuration Guide > Configuring Siebel Analytics in the Windows Environment > Process of Configuring Scheduler Server for Stand-Alone Analytics >

Creating Analytics Scheduler Databases and Tables for the Scheduler

This task is part of the Process of Configuring Scheduler Server for Stand-Alone Analytics.

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

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

To create a database and tables for use by Analytics 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).

    Use the appropriate procedure for your back-end database, as shown in Creating Analytics Scheduler Databases and Tables for a Relational Database.

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

Table 17 gives brief descriptions of the database tables used by Siebel Analytics Scheduler.

Table 17.  Analytics Scheduler Table Names and Descriptions
Table Name
Table Description

S_NQ_ACCT

Siebel Analytics Server generates Usage Tracking data files (if usage tracking is enabled in NQSConfig.INI). A sample JavaScript has been bundled with the Siebel Analytics Server software that extracts information from the Usage Tracking files and loads them to a table in the relational database. The S_NQ_ACCT table stores all the information regarding Accounting Data.
For information about usage tracking, see Siebel Analytics Server Administration Guide.

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.

    
Siebel Analytics Installation and Configuration Guide