17.10 - Defining a Workload Exception - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)
  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.