Toad World® Forums

Set Timer to Stop and Redo Automation if process runs too long?

Hey,

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!

Chad King

Hi Chad,

Unfortunately there is no such functionality. I create enhancement request QAT-1400

Thanks

Aleksey