I set Toad for Data Analysts to export new data into a new excel file that a date time stamp on the file name. How do I set TDA to recognize the new file name (refers to the new data/time stamp) that is generated each time the export is done?
Our script truncates a table, gets new data, enter it in a new table, do an export on that new table, they we add the date stamp suffix, and we need TDA to automate the sending of that file (with a new / different filename due to the date time stamp) out as an email.
Create the whole process in TDA including the Export Activity. Ensure to check mark the "Add date/time suffix to filename" option. Next create an Send Email Activity right after the Export Activity, and set the Send Email Activity to send the Attachments (Collection) and look for the Export Activity filename i.e. "TDA_Export #yyyy-MM-DD HH-mm-ss#.xlsx".
