Defining User-Defined Events in the State Matrix

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
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.