We are trying to implement a filter that would restrict users from returning more than 10,000,000,000 rows however there seems to be a restriction to 10 characters restricting us to 1,000,000,000, any ideas?
Is there any way in TASM to set up an exception to abort queries based on the time in which they are in "acive state"?
For example, if a query is in delayed state for half an hour and then it goes into active state (the total time on system is half hour but I would consider this the start time and if the start time crosses 1 hour, the query should abort)
If I put the exception on "Duration" that time would include (time in active state + time in delayed state) and this is not working for me.
Can you please let me know if exception can be done on "active state" time?
Have you tried the "Elapsed TIme" in the exception criteria? I believe that should give you the time since the query came into the active state.