Bookshelf Home | Contents | Index | PDF     

Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring Oracle Business Intelligence Scheduler > Oracle BI Scheduler Components and Functions >

About Oracle BI Scheduler Tables

This topic is part of the Oracle BI Scheduler Components and Functions.

Table 17 gives brief descriptions of the database tables used by Oracle BI Scheduler. The scripts are located in OracleBI_HOME\server\Schema.

If usage tracking is enabled in NQSConfig.INI, then the Oracle BI Server generates Usage Tracking data files. A sample JavaScript is provided, which 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. (For information about usage tracking, see Oracle Business Intelligence Server Administration Guide.)

Table 17. Tables Used by Oracle Business Intelligence Scheduler
Table Name
Table Description

S_NQ_JOB

This table is used by Scheduler to store information about scheduled jobs.

S_NQ_INSTANCE

The S_NQ_INSTANCE table stores information about scheduled job instances.

S_NQ_ERR_MSG

This table stores error messages for Scheduler job instances that do not complete successfully.

S_NQ_JOB_PARAM

This table holds information about Scheduler job parameters for scheduled jobs.

  
Oracle Business Intelligence Infrastructure Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.