Interaction between Teradata Alerts and Teradata Database | Teradata Viewpoint - 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
Published
February 2022
Language
English (United States)
Last Update
2022-05-30
dita:mapPath
ktu1628075596955.ditamap
dita:ditavalPath
acl1501004736403.ditaval
dita:id
B035-2207
lifecycle
previous
Product Category
Analytical Ecosystem
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.