Teradata : Control a query using its processing time

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.

Teradata : Control a query using its processing time

Hi,

 

I have a task in which i have to run a TERADATA sql query through unix only for a specified amount of time (2 minutes). If it runs for more then that time i want to abort it.

I checked in "Teradata Dynamic Workload Manager" still did not find any solution.

Please let me know if there is any attributes for .SET operator which can be used to set this max time taken.

 

Thanks

Dinesh

1 REPLY
Enthusiast

Re: Teradata : Control a query using its processing time

if you have access to tasm ,in  tasm  we can kill the session if its run from a specific id, utility , with specific query band for more than a given time