Profile Scheduler Settings
The Profile Scheduler Settings panel allows the user to define various criteria to control processing in Profile Scheduler.
- From the Profile Scheduler panel, select File, then click Settings. The Profile Scheduler Settings > General panel appears.
- Use the following table to enter data in the Profile Scheduler Settings > General panel:
- Use the following table to enter data in the Profile Scheduler Settings > Custom Table Loads panel:
- Use the following table to enter data in the Profile Scheduler Settings > Email panel:
- The About panel displays insightsoftware's contact information. Click the Online Manuals link to access the online user manual.
- Click OK. The system processes the changes made in the current panel, then closes it.
Field |
Description |
---|---|
General Options: |
|
Process Timeout (minutes) |
Specify the maximum time (in minutes) allowed for a job to run. |
Enhanced Logging |
If selected, additional logging is recorded. For optimal processing, once an error has been resolved, it is recommended to clear the log file and, unselect the option (see Profile Scheduler View Log for more information). |
Field |
Description |
---|---|
Data Replacement Threshold Options: |
|
Number of Existing Target Rows |
Specify the minimum number of rows which must exist in the target table, in order for the system to determine whether or not to change the update order for more efficient processing. |
Percent of New Rows to Existing Target Rows |
Specify the minimum percent of new rows to existing target rows which must exist, in order for the system to determine whether or not to change the update order for more efficient processing. |
Note: If processing a Custom Table Load job in update mode (for example, Replace Data option is not selected), the system copies the appropriate rows from the source table to a temporary table, then copies all rows from the target table which are not already in the temporary table, to the temporary table, then deletes the target table, and renames the temporary table to the new target table. If the number of rows in the target table are far greater than the number of rows in the temporary table, this method is inefficient. If the tables exceed the data replacement threshold options specified, the system will change the update direction and move the temporary table rows to the target table, rather than moving the target table rows to the temporary table.
Field |
Description |
---|---|
Email Options: |
|
SMTP Options: |
|
SMTP Mail Server |
Specify the SMTP mail server to be used for email notifications when a job fails. |
SMTP Sent "From" Address |
Specify the "from" email address to be assigned to email notifications for failed jobs. |
SMTP Advanced Options (Optional): |
Specify, if necessary, optional settings for the authentication account name and password, the SMTP port number, and SSL (Secured Socket Layer) support. |