I want to automate a script that will send out an excel file to each staff person all of the orders that their clients have processed in a month. Currently I build one script per staff person, based on a customized export template, which is based on a customized sql query, and schedule it. This is fine for a small department. But recently I’ve been asked to replicate this for a department that has over 100 people in it. There has to be an easier way.
What I would love to do is tell TOAD to loop through a query and for every staff person, select to an excel file and then email that file to the associated email address. Can this be done with Toad for DA. IF not, what is the appropriate application/tool to do this type of automation?
Thanks in advance