Database

—Connection Pool

Database Type

Oracle Scheduler back-end database type. Choose a type from the drop-down list.

Call Interface

The type of call the connection to the database makes. The call you choose from the drop-down list determines the application programmer interface (API) used to access the data source. The types of call interfaces in the list varies depending on the database type selected.

Data Source Name

Identifies the data source name (DSN) of the data source to use for the connection. The DSN must contain valid logon information for a data source. If the information is invalid, the database logon fails. For example, if the DSN of the Oracle BI Scheduler back-end database is ORCL8_Scheduler, you enter ORCL8_Scheduler in this field.

User name

The user name that Oracle BI Scheduler uses to log on to the data source. The user name must have read and write permissions to the back-end database and must be the same as the table owner for databases that require fully qualified table names (for example, ORACLE.S_NQ_JOB).

Password/Confirm Password

Password used to log on to the data source. For security, the password is encrypted in the registry.

Timeout (Minutes)

Specifies the amount of time in minutes that a connection to the data source remains open after an operation completes.

During this time, new operations use this connection rather than open a new one, up to the number specified for Maximum Connections. The time is reset after each completed connection request.

Specify a value of 1 or greater. The default value is 60.

Maximum Connections

Maximum number of database connections Oracle BI Scheduler can open concurrently. Specify a value of 1 or greater. When this limit is reached, the connection request waits until a connection becomes available. The default value is 5.

Database

—Database Tables

Jobs

S_NQ_JOB is a database table used to store information about scheduled jobs.

NOTE:  For information about modifying the database table names, see the Oracle Business Intelligence Applications Installation and Configuration Guide.

Instances

S_NQ_INSTANCE is a database table used to store information about job instances.

Parameters

S_NQ_JOB_PARAM is a database table used to store information about job parameters.

Messages

S_NQ_ERR_MSG is a database table used to store information about job instances that do not complete successfully.

General

Scheduler Script Path

Refers to the path where Oracle BI Scheduler-created job scripts are stored. In general, you should not add or remove scripts from this directory. By default, this field is set to $OracleBI\Scripts\Scheduler where $OracleBI is the location in which the Oracle BI software is installed.

Default Script Path

Path where user-created job scripts (not iBots) are stored.
If a filename is entered in the Script field when adding or modifying a job, Oracle BI Scheduler examines the contents of this directory for the specified file. However, if a full path is given in the Script field, this directory is not examined. By default, this field is set to $OracleBI\Scripts\Common where $OracleBI is the location in which the Oracle BI software is installed.

Temporary File Path

Path that specifies where temporary files are stored during Oracle BI Scheduler execution.

Bulk Fetch Buffer Size (bytes)

Used in the database gateways. Specifies the maximum size in bytes of a bulk fetch page for retrieving data from a data source. The default value is 33,792 bytes.

Server Port Number

Defaults the Scheduler port number.

Purge Old instances after X days

Specifies the number of days after which old job instances are deleted from the back-end database automatically. To prevent old job instances from being deleted automatically, set the value to 0 (zero).
The default value is to delete after seven days.

Purge DB every X minutes

Oracle BI Scheduler updates the tables and flags the affected rows as deleted.

NOTE:  Oracle BI Scheduler does not actually issue SQL DELETE statements when jobs or instances are removed.

After every X minutes (where X is defined as the value of this field), the actual SQL DELETE statements are issued. The default value is every 60 minutes.

Minimum Execution Threads

Specifies the minimum number of multiple threads in the Oracle BI Scheduler thread pool.

Maximum Execution Threads

Specifies the maximum number of multiple threads in the Oracle BI Scheduler thread pool.

Pause When Service Starts

Specifies that no jobs should execute when Oracle BI Scheduler starts. While Oracle BI Scheduler pauses, users can add, modify, and remove jobs. However, no jobs execute. Select Service Management > Continue Scheduling to continue with regular execution.

Administrator Name

Specify a user with administrator's privileges in this field to allow Oracle BI Scheduler and Oracle BI Presentation Services to log onto the Oracle BI Server as other users. Oracle BI Scheduler runs jobs on the Oracle BI Server and Oracle BI Presentation Server for users without storing the user's password. The user specified must be a Repository Administrator with the ability to log in as other users, and have basic access to the Presentation catalog (to access the shared folder).

NOTE:  For information about changing the administrator name, see the Oracle Business Intelligence Infrastructure Installation and Configuration Guide or the Oracle Business Enterprise Edition Deployment Guide.

Administrator Password/
Confirm Password

Password for the administrator with privileges to log on as other users. The password is encrypted in the registry.
You can change it by using the Job Manager (Windows) or schconfig.exe (UNIX).

NOTE:  For information about changing the administrator name, see the Oracle Business Intelligence Infrastructure Installation and Configuration Guide or the Oracle Business Enterprise Edition Deployment Guide.

Advanced

Use Secure Socket Layer

This box is unchecked by default. Select this box to enable the Secure Socket Layer (SSL) for the Scheduler. After selecting this box, you must enter the SSL information.

NOTE:  The SSL fields allow you to configure Scheduler to communicate via SSL. For more information about setting up and locating the SSL information to enter into these fields, see the Oracle Business Enterprise Edition Deployment Guide.

SSL Certificate File Path

SSL Certificate Private Key File

SSL File Containing Passphrase

SSL Require Client Certificate

SSL Certificate Verification Depth

CA Certificate Directory

CA Certificate File

SSL Trusted Peer DNs

SSL Cipher List

Script Server Port

The port used for interprocess communication between the script processes and the Scheduler process. This port will only accept connections from the same machine on which Scheduler is running. The default port is 9707.

Participant in Cluster

The box is unchecked by default. If you want the Business Intelligence Server to be part of a cluster and wait for a connection from the Cluster Controller Server to notify it, select this box. If you select this box, you must also specify a value in the Cluster Monitor Port field.

NOTE:  For information about clustering, see the Oracle Business Enterprise Edition Deployment Guide.

Cluster Monitor Port

The port to which the Business Intelligence Server listens on the Cluster Controller Server. The default port is 9708.