Defining a Workload Exception - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Workloads.
  3. Select or create a workload.
  4. Click the Exceptions tab.
  5. Next to Exceptions, click .
  6. Enter a name.
  7. [Optional] Enter a description.
  8. Under Criteria, select an option from the list, click , and specify the additional required information.
    You can select and add multiple criteria. If you do so, all criteria must be satisfied for the exception to be triggered.
  9. For qualified criteria marked with *, enter a value in the Qualification Time box.
  10. Under Actions, select one of the following actions to be performed when the specified criteria are met:
    Action Description
    Notification Only Sends notification and takes no other action.
    Abort Stops the query.
    Abort Selects Only Stops the query only if it is a SELECT.
    Change Workload to Changes the query to the workload you select from the list.

    This action is unavailable for Blocked Time or Elapsed Time.

  11. [Optional] Under Notifications, enable any of the following options for the start or the end of the event:
    Notification Description
    Send Alert Specifies the action to trigger.
    Run Program Specifies the Alerts registered programs to trigger.
    Post to QTable The string you enter is posted to the QTable.
  12. Click OK.