Most of our users love to use the “Save As” function in the right click menu for the data grid. But sometimes the user has to run the same query numerous times and repeat the steps to save the data off to the file format of their choice. To make matters easier we have introduced “Toad Actions” to automate this process.
 

Run the query in the Editor. And then right click on the data results and select “Save As”.

Continue to select your file format, and any options you want. Also remember to set a destination location for the new file. 
 
Once completed, on the top right hand corner of this window, click the little yellow lightening bolt icon.

This will prompt you to give this action a name. Please provide a meaningful name and hit OK.
 

Under the View Menu, select the Action Palette option. This will bring up the Toad Action window.
 

Located in this window will be the new Action you just created. On the top of this window will be a “Schedule” icon underneath the green triangle icon.
 

Click on this and you can schedule the data extraction.
 

Just keep in mind that this is using Windows Task Scheduling to setup the job and you must have Windows up and logged in. You do not need to have Toad running in order for this to work. Now sit back and enjoy, while Toad automatically exports data for you to your desired location and in your desired file format.