Kill Query after some time

Database
New Member

Kill Query after some time

Hi Experts,

We have been running queries from a SAP reporting tool to Teradata.

Sometimes due to load on teradata the queries tend to take More time and the timeout at the SAP site 10 Mins happens and blabk report has been send.

 

What we are looking is that If we have a Mecanism in teradata throgh which we can auto kill a query if running for more then X Minutes, It will fail the report with error and a notification can be set up from SAP and can be retried after a specfic interval.

 

No specfic query and can be anyone of them

 

new to terdata

 

 

1 REPLY
Senior Apprentice

Re: Kill Query after some time

This could be done with Teradata's Workload Management, defining an exception for this user on Elapsed Time. Talk to your DBAs for details.