Defining User-Defined Events in the State Matrix - 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
A user-defined event is a SQL request that you define. User-defined events can be planned or unplanned. To create an event that only sends out a notification, create the event, but do not assign it to any planned environment or health condition. When the event occurs, the notification action you specified is triggered.
  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click States.
  3. Next to Unplanned Events (with TASM license only) or Planned Events, click .
  4. Next to Available Events, click .
  5. Select User Defined Event.
  6. Enter a name.
  7. [Optional] Enter a description.
  8. [Optional] If you are creating the user-defined event as a planned event, you can select Create New Corresponding Planned Environment to automatically create a planned environment that this event triggers.
  9. Under Activate/Deactivate Event, copy the appropriate SQL request text.
  10. Paste the text into an SQL script.
  11. [Optional] Under Configure 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.
  13. [Optional] Do one of the following:
    Event Type Description
    Unplanned Drag the event to a health condition and click Close (with TASM license only).
    Planned Drag the event to a planned environment and click Close.
  14. Click Save.