Defining a Workload Exception - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
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
    Notify Database User Sends an email alert to database user when the query stops. This option is available if you have selected only Abort/Abort Selects from actions.
    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.