I was wondering if there’s a way in Toad Data Point through automation to set a while or loop activity to say if a query or process runs or does not finish in a certain amount of time (say 2 hours), to stop it and restart that process?
This would be useful, because for some reason I have some query processes that run just for 10 minutes or so, but are getting hung up somehow and not finishing for hours. I’d like to be able to stop it and possibly restart it through a loop when it runs into this until successful completion.
Any ideas would be wonderful. As always, thanks so much!