I searched through some old posts and found some answers that almost, but not quite, address the issue that I have
We have an Oracle database where the tables are not uniformly updated, and we’re having an issue with our Toad automations against that database - either because one or more of the tables don’t exist when the script runs, or they haven’t been refreshed and the scripts pull old or no data.
The Oracle database does have a “status” table that lists all of the refreshed tables, their status and when they were last updated. Older scripts written in VBScript have a built-in loop that checks their dependencies on this table, and if all of the tables aren’t ready, they go back to sleep for a while - 10 mins, 5 mins, just depends on the author.
I’ve been trying to accomplish the same thing in TDP using a WHILE loop, but I can’t quite seem to get it right. All I’m trying to do is check that I get X number of rows returned from my Execute Script activity which is what checks against the status table - if all the tables are loaded, X number of rows will be returned; anything less than that and I want it to go back to sleep for a while and then check again.
Anyone had to do something like this that’s willing to share their solution?