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
This could be done with Teradata's Workload Management, defining an exception for this user on Elapsed Time. Talk to your DBAs for details.