Create and Edit Scheduler Profiles - Query Scheduler

Teradata Query Scheduler Administrator Guide

Product
Query Scheduler
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2511
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.