I have a bunch of .bat files I need to execute daily. This list is dynamic and will change from day to day. Some may get added, others may drop off.
I may have thousands of these and I would rather not have to schedule them and maintain that schedule for each of these individually.
I was thinking of storing the current list in a single column database table and reading its contents. With the results, I would grab the first row, set its value as a variable that represents a file path and file name, run that .bat file, move to the next row and repeat until the end of the list.
For example, imagine the following table:
SELECT * FROM table;
I want to then take this result and do the following:
Is it possible to create a loop, read these values and pass them to a file path variable?
Thank you in advance!