Bookshelf v7.5: Schemas

The associated schemas are located in the Schema subdirectory in the Siebel Analytics software installation directory. This directory holds several SQL scripts that can be used by major commercial databases to create the tables in the Scheduler's schema.

The schemas include four tables: S_NQ_JOBS, S_NQ_INSTANCES, S_NQ_JOBPARAMETERS, and S_NQ_ERRMSGS. The contents of these tables are implementation specific. For information about creating these tables, see Siebel Analytics Installation and Configuration Guide.

NOTE: The Siebel Analytics Scheduler tables are included in version 7.5 of Siebel eBusiness Applications OLTP. Therefore, if you have version 7.5 of Siebel eBusiness Applications installed, you do not need to install the Siebel Analytics Scheduler tables.

The Siebel Analytics Scheduler tables are not included in versions of Siebel eBusiness Applications before Release 7.5. Therefore, if you are upgrading from Release 7.0.4, you must create the version 7.5 Scheduler tables and migrate your data from the old tables to the new tables. For more information, see Upgrading from Siebel Analytics Version 7.0.4.

Table 1. Schema Tables
Table	Description
S_NQ_JOBS	Stores information about scheduled jobs.
S_NQ_INSTANCES	Stores information about instances.
S_NQ_JOBPARAMETERS	Stores information about job parameters.
S_NQ_ERRMSGS	Stores information about job instances that do not complete successfully.

Do not change the table or column names; they are used internally by Siebel Analytics Scheduler. The data types for each column should remain true to the intent of the schema. For example, if the job ID is defined as an integer, do not change it to a varchar. However, increasing the number of characters in a varchar column is an acceptable change.

The schemas also store path and file names to job scripts, which allows for easy updates to several jobs if they share a script.

For enterprise applications, you need to use a supported commercial database. For information about setting up a commercial back-end database for use by Siebel Analytics Scheduler, see Siebel Analytics Installation and Configuration Guide.

NOTE: There is a one-to-one relationship between the back-end database and Siebel Analytics Scheduler. Do not configure multiple Siebel Analytics Scheduler applications to use a single back-end database.