Table 12. Analytics Scheduler Job Manager Scheduler Tab Fields
|
|
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. |
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 Scheduler back-end database is ORCL8_Scheduler, you enter ORCL8_Scheduler in this field. |
Database Type |
Siebel Analytics Scheduler back-end database type. Choose a type from the drop-down list. |
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, 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 $SiebelAnalytics\Scripts\Common where $SiebelAnalytics is the location in which the Siebel Analytics software is installed. |
Maximum Connections |
Maximum number of database connections Siebel Analytics 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. |
Maximum Execution Threads |
Scheduler is multithreading and uses a thread pool. This field specifies the maximum number of threads that are used in Scheduler's thread pool. |
Minimum Execution Threads |
Specifies the minimum number of multiple threads in Scheduler's thread pool. |
nQS (Siebel) Administrator Name |
Specify a user with administrator's privileges in this field to allow Siebel Analytics Scheduler and Siebel Analytics Web to log onto Siebel Analytics Server as other users. Scheduler runs jobs on the Analytics Server and Analytics Web 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 Web catalog (to access the shared folder). |
nQS (Siebel) Administrator Password/Confirm Password |
Password for the Siebel 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). |
Password/Confirm Password |
Password used to log on to the data source. For security, the password is encrypted in the registry. |
Pause When Service Starts |
Specifies that no jobs should execute when Siebel Analytics Scheduler starts. While Siebel Analytics Scheduler pauses, users can add, modify, and remove jobs. However, no jobs execute. Select Service Management > Continue Scheduling to continue with regular execution. |
Purge DB every X minutes |
Siebel Analytics Scheduler updates the tables and flags the affected rows as deleted. NOTE: 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. |
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. |
Scheduler Script Path |
Refers to the path where Siebel Analytics 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 $SiebelAnalytics\Scripts\Scheduler , where $SiebelAnalytics is the location in which the Siebel Analytics software is installed. |
Temporary File Path |
Path that specifies where temporary files are stored during the execution of Siebel Analytics Scheduler. |
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. |
User name |
The user name Siebel Analytics 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, SIEBEL.S_NQ_JOB). |