Bookshelf: Schemas

The associated schemas are located in the Schema directory 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_JOB, S_NQ_INSTANCE, S_NQ_JOB_PARAM, and S_NQ_ERR_MSG. 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 the Siebel eBusiness Applications OLTP, version 7.5 and later. If you have version 7.5 (or later) 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 prior to Version 7.5. If you are upgrading from any version prior to Version 7.5, contact Technical Support for assistance.

Table 2. Schema Tables
Table	Description
S_NQ_JOB	Stores information about scheduled jobs.
S_NQ_INSTANCE	Stores information about instances.
S_NQ_JOB_PARAM	Stores information about job parameters.
S_NQ_ERR_MSG	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, providing 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.