I am new to Toad and have a question related to ‘Automation Designer’ picking up a file dynamically. Below is the problem description.
I have a SELECT query which is placed in a file, “Account.sql”. The requirement is to ‘Schedule’ an ‘Export Dataset’ of this SQL query to a CSV file. By using ‘Automation Designer’, I created a new ‘App’ to perform this task successfully. Below are the steps.
a. Create a new App.
b. Under the ‘Import/Export’ tab, choose the action, ‘Export Dataset’.
c. Right-click the action ‘Export Dataset’ choose Properties and manually copy the SQL query in ‘Dataset’ tab.
d. Schedule/Run the App and it works fine.
However, the challenge here I have is, copying the SQL query manually(Step-c above) whenever it changes(it changes often). So, is there a way of making Toad to dynamically pick the ‘Account.sql’ file from a specified location whenever it is scheduled to run?