I inherited about 20 queries that have to be run every day in Toad (version 18.104.22.168) for DB2 on z/OS and we manually email the results to various business users. Most of the queries have a date parameter we update every day before running.
I’m trying to use Toad automation scripts to automate this process. I plan to make each of the 20 queries into separate Toad automation scripts. I’d like to have a “master” automation script that would prompt me for the needed dates, then it would call each of the 20 and pass them the dates provided.
I’ve run into several problems, so I’m starting to wonder if what I’m trying to do is possible or feasible? Does anyone out there use Toad Automation Scripts and if so have you done anything like this, or do you have any suggestions or tips?
Thanks for any advice.