Exception Actions | Teradata Vantage - 17.00 - Exception Actions - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K

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.