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) >

About Siebel Analytics Scheduler Tables

---

This section gives brief descriptions of the database tables used by Siebel Analytics Scheduler. If you are not using Siebel Analytics Scheduler, you do not need the information in this section.

NOTE:  For Siebel Analytics applications, the Scheduler tables were created during the installation of Siebel 7.0.x and 7.5.x operational applications. Siebel Analytics 7.7 uses updated Scheduler tables. These updates are delivered as .sif files that must be applied by your Siebel Administrator. For procedures on applying .sif files, see Siebel Data Warehouse Installation and Administration Guide.

• 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.

• S_NQ_JOB

  The Siebel Analytics Scheduler requires a relational database table to store information regarding the scheduled jobs. The S_NQ_JOB table stores this information.

• S_NQ_INSTANCE

  The Siebel Analytics Scheduler requires a relational database table to store information regarding the instances of the scheduled jobs. The S_NQ_INSTANCE table stores information pertaining to job instances.

• S_NQ_ERR_MSG

  This table stores error messages for Siebel Analytics Scheduler job instances that do not complete successfully.

• S_NQ_JOB_PARAM

  This table holds information about Siebel Analytics Scheduler job parameters for scheduled jobs.

You can either create a new database to store the tables or use an existing one. After you have created a database, 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