Interaction between Teradata Alerts and Teradata Database | Teradata Viewpoint - 17.10 - Interaction between Teradata Alerts and Teradata Database - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Viewpoint
Release Number
17.10
Release Date
October 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-2207-101K
Language
English (United States)
Teradata Alerts has limited interaction with Teradata Database. The three components that interact with the Teradata Database are:
  • BTEQ alert actions
  • SQL alert actions
  • Alerts processed by the Teradata Viewpoint alert request data collector

Teradata Notification Service for Windows and Teradata Notification Service for Linux can execute BTEQ scripts. The version of BTEQ that is installed on the Windows Server or Linux Server must be compatible with the version of the Teradata Database that the BTEQ scripts are executing against.

Teradata Alerts running on the Viewpoint Server executes SQL alert actions using the Teradata JDBC driver. The queries entered by the administrator must be compatible with the Teradata Database where the queries will be executed.

Teradata Viewpoint alert request data collector monitors the dbcmngr.alertrequest and dbcmngr.monitorrequest tables for alert requests. Teradata Alerts supports the same versions of the Teradata Database that Viewpoint monitoring supports.