Hello - I’m not entirely new to Toad, but have just joined this forum today. I didn’t find anything that matched what I was trying to achieve either.
I have a recurring problem where we use Xen Desktop to run Toad. There’s a query that I run that typically takes several hours (I’ve been working on tweaking this as well), so sometimes the query will finish but Xen closes before I can retrieve the results.
I can see the session in Session Browser, although it shows Inactive, which is more than likely because the query has completed. Am I still able to retrieve those results from Toad or do I have to rerun the query?
If you’re running this query and need the result, could you store the result into Excel (or another such format)? If so, you could use the Export Dataset action and have it save the results off for later use. Then the action could be scheduled and automated and even send you an e-mail when it’s done.