Define Exception to Send Alert to dbaser on Abort/Abort Selects | Viewpoint - Example: Defining an Exception to Send an Alert to Database User on Abort/Abort Selects - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Teradata Viewpoint
Teradata Workload Management
Release Number
April 2024
English (United States)
Last Update
Product Category
Analytical Ecosystem
Suppose you want to send an email alert to the dbauser having the e-mail id, during core hours when a period event begins and ends.
  1. In the Monitored Systems portlet, configure TEST1 as a Teradata Active System Management (TASM) system.
    1. Next to Systems, select "", then select Add Teradata System.
    2. In System Nickname, type TEST1.
    3. Select the Enable system check box.
    4. In the TDPID box, type the TDPID of the TEST1 system.
    5. [Optional] Enter the site ID assigned by Teradata Customer Services.
    6. Enter a login name and password.
    7. Click Apply.
  2. In the Monitored Systems portlet, configure the data collectors.
    1. From the Systems list, select TEST1.
    2. From the Setup list, select Data Collectors.
    3. From the Data Collectors list, select the following collectors, enable them, and select Apply for each:
      • TASM Config
      • TASM Distribution
      • TASM Exception
      • TASM State
      • TASM Summary
      • Alert Request
  3. In the Alert Setup portlet, configure delivery settings.
    1. From the Setup Options list, select Delivery Settings.
    2. From the Delivery Types list, select Email.
    3. In the SMTP Host box, type as the SMTP host address of the outgoing (SMTP) email server.
    4. Select the Enable email check box.
    5. From the Port list, select Use default port to use the default port 25.
    6. In Server Timeout, type 30 seconds.
    7. Keep the default Anonymous login.
    8. In the Reply-To box, type
    9. Leave the Advanced box blank.
    10. In the Test Recipient box, type
    11. Select Test to verify the SMTP server delivers the email to
    12. Click Apply.
  4. In the Alert Setup portlet, create an Action Set.
    1. From the Setup Options list, select Alert Presets.
    2. From the Preset Options list, select Core Hours.
    3. Verify the core hours are correctly set for your environment.
    4. Under Database User Alerts, select User Mapping.
    5. Select the system.
    6. Enter the username and password.
    7. Enter the table or view name as configured in the selected Teradata Viewpoint system. Refer Database User Alerts for details.
    8. Verify the test.
    9. Click Apply.
  5. In the Workload Designer portlet, create a period event that triggers the alert email.
    1. From the For System list, select TEST1.
    2. Select "".
    3. From the General tab, in the Name box, type TEST1_alert_email.
    4. Click Save.
    5. From the ruleset toolbar, click States.
    6. Hover over Planned Events, and click "".
    7. Select "" next to Available Events.
    8. Select Period Event.
    9. In Event Name, type CoreEnvironment.
    10. Select Create New Corresponding Planned Environment to automatically create a planned environment that this event triggers.
    11. Select Day of Week, and select all weekdays.
    12. Select Start Time, with a 9 am Start Time and 5 pm End Time.
    13. In the Exceptions, after configuring the exception criteria, select only Abort/Abort Select from Actions.
    14. Select Notify Database User from Notifications.
    15. Click OK.
    16. Select Close.
    17. Click Save.
  6. In the Workload Designer portlet, activate the ruleset.
    1. Under Working, select the TEST1_alert_email "".
    2. Select Make Active.
    3. In the Confirm Activation Request dialog box, select Activate.
  7. In the email inbox for the account, check for messages from
    The alert collection upon TDWM abort happens from Alert Request Collector rate.