I have a handful of SQL queries that I have been running nearly every work day to monitor a few projects on hand. Each result then gets put into various spreadsheet files etc. It's interesting enough that I haven't minded doing it, but I admit it's more timeconsuming than it needs to be. I have GoAnywhere Director and decided I should probably just set up a job to run the queries for me and email me the results to save some time.
The only one I haven't figure out how to handle is my query that parses the latest QHST file for only certain entries. The query itself works just fine, but I only see about 70-80 results per file and when I see that a new QHST file is created, I update the query manually and rerun it.
If I program a scheduled job to run the checks, I don't know how to handle this aspect.
Is there a way to run query against a library to get table names?
It seemed like there should be a way, but I haven't found it. (I've seen some solutions that are for other systems or require API usage, but I'm looking to just run simple queries. Having to write a full blown program for this, just is too much side effort for everything else I'm juggling.)