Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Installing Siebel Analytics Software in the Windows Environment > Siebel Analytics Scheduler Tables (Stand-Alone Only) >

About Analytics Scheduler Tables

---

Siebel Analytics Server contains Siebel Analytics tables. The first is used by the Siebel Analytics Server; the remaining four are used by Siebel Analytics Scheduler. Table 7 gives brief descriptions of the database tables used by Siebel Analytics Scheduler. The Siebel Analytics Scheduler requires a back-end database table to store information regarding the instances of the 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). See Creating Database Tables for Siebel Analytics Scheduler.
• If you are using usage statistics, create the table in SAACCT.xxx.sql.

Table 7.  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 back-end 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	Stores information regarding the scheduled jobs.
S_NQ_INSTANCE	Stores information pertaining to job instances.
S_NQ_ERR_MSG	Stores error messages for Siebel Analytics Scheduler job instances that do not complete successfully.
S_NQ_JOB_PARAM	Stores information about Siebel Analytics Scheduler job parameters for scheduled jobs.

Changing Scheduler Table Names

If you are not using Siebel Analytics Scheduler, you do not need the information in this section.

You can change the names of the tables that Scheduler uses by adding settings to the Windows registry, as shown in the following example. (A new key, DB Column Names, has been created.)

[HKEY_LOCAL_MACHINE\SOFTWARE\Siebel Systems, Inc.\Siebel Analytics\Scheduler\7.5\DB Column Names]

Name	Type	Data
TABLE_JOBS	REG_SA	S_NQ_JOB
TABLE_INSTANCES	REG_SA	S_NQ_INSTANCE
TABLE_PARAMS	REG_SA	S_NQ_JOB_PARAM
TABLE_ERRMSGS	REG_SA	S_NQ_ERR_MSG

The values that you create in the data string become the values used for Scheduler table names.

NOTE:  Changing these registry values requires a restart of Scheduler.

Bookshelf Home | Contents | Index | Search | PDF