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 | ![]() ![]() ![]() ![]() |
Siebel Analytics Installation and Configuration Guide, Version 7.7, Rev. A Published: 11 March 2004 |