Create and Edit Scheduler Profiles

1 Click Configuration > Scheduler Profiles.

The Scheduler Profiles dialog box appears.

2 From the Select Type list, choose one of the following types of scheduler profiles to create:

Account

Profile

Role

User

3 Do one of the following:

If creating a new profile, click New.

If editing an existing profile, click Edit.

The Scheduler Profile Properties dialog box appears with the Scheduling tab selected by default.

4 Complete the following options in the Scheduling tab:

Table 10: Scheduler Profile Properties: Scheduling Tab
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: No scheduling: Disables scheduling. No requests can be scheduled, effectively disabling the feature for this user, group, or account. Onetime only: Runs the request once. Onetime & Recurring: Runs the request more than once such as daily, weekly, or monthly.
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.

5 Select the Results Tables/Files tab.

6 Complete the following options in the Results Tables/Files tab to set up results parameters:

Table 11: Scheduler Profile Properties: Results Tables/Files Tab
Option	Description
Allowed Results Type	Select the location where results of a scheduled request are stored: Save in database: Stores the results in a database table. Save in file: Stores the results in a file. Save in database or file: Stores the results in a database table, a file, or either. If selecting this option, the user can choose the destination when scheduling a request.
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.

7 Select the User Options tab.

8 Complete the following options in the User Options tab:

Table 12: Scheduler Profile Properties: User Options Tab
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.

9 Click OK.

10 Click Close to close the Scheduler Profiles dialog box and return to the Teradata Query Scheduler Administrator.

Create and Edit Scheduler Profiles - Query Scheduler

Teradata Query Scheduler Administrator Guide