Exception Actions | Teradata Vantage - 17.10 - Exception Actions - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)

When you create an exception, you define what TASM should do automatically if it finds the exception.

Choose from the following actions.
Action Description
Notification Only Sends notification and takes no other action.
Abort Stops the query.
Abort Selects Only Stops the query only if it is a SELECT.
Change Workload to Changes the query to the workload you select from the list.

For all exceptions, TASM logs the exception to TDWMExceptionLog and captures the SQL in DBC.DBQLSqlTbl.

A Change Workload to action will be overridden and ignored if the PM/API request TDWM WD ASSIGNMENT has been issued and it affects this request.