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.
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