Siebel Analytics Scheduler Guide > Using Siebel Analytics Scheduler > Concepts and Terms Related to Siebel Analytics Scheduler >
Siebel Analytics Scheduler Schemas
The database schemas associated with Scheduler are located in the $INSTALLDIR \Schema directory. This directory holds several SQL scripts that can be used by major commercial databases to create the tables in Siebel Analytics Scheduler's schema. The schemas include four tables:
- S_NQ_JOB
- S_NQ_INSTANCE
- S_NQ_JOB_PARAM
- S_NQ_ERR_MSG
The following are characteristics of Siebel Analytics Scheduler schema tables:
- The Scheduler tables are included in the Siebel operational applications transactional database, version 7.7. If you have version 7.7 of Siebel operational applications installed, you do not need to install Siebel Analytics Scheduler tables. These tables have been included in versions of Siebel operational applications since version 7.5.
- The contents of the schema tables are implementation-specific. For information about creating these tables, see Siebel Analytics Installation and Configuration Guide.
- 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.
Table 5 describes the information stored in each schema table.
Table 5. Analytics Scheduler Schema Tables
|
|
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. |
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 type, do not change it to a varchar type. 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 easy updates to several jobs if they share a script.
|