Create and Edit Scheduler Profiles - Query Scheduler

Option

Description

Profile Type

(Read-only) See the profile type chosen from the Select Type list on the Scheduler Profiles dialog box.

Name

(Read-only) See the name of the Teradata Database object selected from the Objects list on the Scheduler Profiles dialog box.

Allowed Scheduling

Select the types of query requests that can be scheduled by this profile:

Workgroup

Select the workgroup specification indicating which scheduled request workgroup the profile should use. The default is DEFAULT_WORKGROUP.

The administrator configures the workgroup specification in the Settings dialog box.

Start Interval

Specify the greatest length of time from the submitted start time that a job can begin to run in days and hours. Default value is one day.

New requests are not accepted if there is no time between the start time and the maximum start interval that a request can execute due to rules or unavailability of an execution time frame.

Job History

Specify the number of days between 1 and 365 that job records are retained before Teradata QS automatically deletes them.

Option

Description

Allowed Results Type

Select the location where results of a scheduled request are stored:

Results Tables Parameters

Results Database

Specify the name of the results database to use as the default. This is the name of the database in which the Teradata QS Server stores the results. This option cannot be used if Save in file was selected as the Allowed Results Type.

Create as Fallback

Specify that the results table is created with the fallback attribute. This option cannot be used if Save in file was selected as the Allowed Results Type.

Create as Multiset

Specify that the results table is created with the multiset attribute. This option cannot be used if Save in file was selected as the Allowed Results Type.

Append user name

Have Teradata QS to automatically append the user name to the results table. This option cannot be used if Save in file was selected as the Allowed Results Type.

Note: When the same results database is used by multiple users, the results table name is modified to include the user name to avoid duplicates if this check box is selected.

Results Files Parameters

Storage Location

Select the results file storage specification where to store results files. This option cannot be used if Save in database was selected as the Allowed Results Type.

Configure the file storage location from the Results File Storage Properties dialog box. See “Manage Results File Storage” on page 42 to learn how.

Optional Sub‑Directory

Specify a relative path beneath the results file storage location where results from this profile are stored. The Teradata QS Server joins the directory corresponding to the selected results file storage path and this relative path to form the full directory path where results are stored. This option cannot be used if Save in database was selected as the Allowed Results Type.

Field Separator Character

Select the character to use to separate record fields when results are saved in a file. This option cannot be used if Save in database was selected as the Allowed Results Type.

Max File Size

Specify the greatest number of bytes (in thousand bytes) allowed for a results file. This option cannot be used if Save in database was selected as the Allowed Results Type.

Results Duration

Specify the number of days between 1 and 365 that results tables or files are retained before they are automatically deleted by Teradata QS. The timestamp for results is reset when the results are replaced or appended to.

Option

Description

Modify start interval

Allow users to modify the maximum start interval in the Query Scheduler Submit dialog box.

Modify results database name

Allow users to modify the results database in the Query Scheduler Submit dialog box.

Modify create Table as Fallback option

Allow users to modify the Create as Fallback option in the Query Scheduler Submit dialog box when saving results to a table.

Modify create Table as Multiset option

Allow users to modify the Create as Multiset option in the Query Scheduler Submit dialog box when saving results to a table.

Modify results File field separator character

Allow users to modify the Field Separator character for results files in the Query Scheduler Submit dialog box when saving results to a file.