Creating a Collect Job - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
The collect job collects automated statistics. You can preview and customize the list of collected statistics and their collect order. The order in which statistics are collected is automatically prioritized by default, but you can change the priority before the collection is run.
  1. From the Jobs tab, click Actions > New Collect Job.
  2. Enter a job name, up to 30 alphanumeric characters.
    The name cannot be the same as an existing job name.
  3. From the Scope tab, click one of the following to specify the objects that will be used to generate collect lists:
    Option Description
    All automated objects Select to collect automated statistics on all objects across the entire system.
    Existing object list Select to collect automated statistics using an existing list that was created for other jobs. Object lists that were externally created outside of the portlet display first.
    Custom object list Select to collect automated statistics using a custom object list.
    1. Click Edit list to customize the object list.
    2. From the Objects tab, use the object browser to either select databases to include all related objects in those databases or select individual objects within those databases.
    3. From the Wildcards tab, use wildcard patterns to add objects to the job scope. Click Add Patterns to take the filter combinations you entered in the filter boxes and create a wildcard in the Wildcard Patterns pane.
    4. Click OK.
  4. Click the Collect List tab and select one of the following:
    Option Description
    Automatically generate the collect list
    1. Select if you want COLLECT STATISTICS statements to be automatically ordered according to system-determined and user-specified importance.

      This option is recommended.

    2. Select Preview list to generate a collect list.
    Use the list below for the next collect only
    1. Select if you want to customize the order of COLLECT STATISTICS statements the next time the job is run.

      This option automatically switches to a system-generated collect list after the job runs once. Use this option when you need to temporarily adjust collection priority to favor statistics that need immediate attention.

    2. Select Regenerate list to clear the current collect list and regenerate a new list.
    3. Click Continue.
    Use the list below for all collections
    1. Select if you want to customize the order of COLLECT STATISTICS statements every time the job is run in the future.
    2. Select Regenerate list to clear the current collect list and regenerate a new list.
    3. Click Continue.

    Choosing this option prevents changes made from the Scope tab and in the Edit Collect Settings dialog box from taking effect, because the COLLECT STATISTICS statement has already been generated.

  5. After the collect list is generated, click Close.
  6. Click the Schedule tab and do one of the following:
    • Click Add Schedule to add a new schedule.
    • Select an existing schedule to edit.
  7. Under Schedule, specify when this job will run.
  8. [Optional] Select the following options:
    Option Description
    Limit to Under Duration, specify the maximum amount of time you want the job to run.
    Resume collect list if not yet complete Under Options, select to enable the following options:
    • Select If complete, restart job to start a job from the beginning if all items on the previous collect list of the job have already been submitted.
    • Select If complete, do nothing to prevent the job from running if all items on the previous collect list of the job have already been submitted.
  9. Click OK.
  10. Click Save.
    The job appears in the list on the Jobs tab.