Can I schedule task from Toad for Oracle?
I need the data set result from SQL in a file (type .txt) everyday.
How can I do it ?
In short, execute the following steps:
1. Run a query.
2. Right click on Data Grid, select Save As.
3. Select Output file type and path file is to saved.
4. IMPORTANT: Click on the Bottom left icon on the Schedule Action.
5. Fill out fields for Task Wizard (When asked for user name and password, this is your Windows OS log in information).
Attached is a Flash file to demonstrate the steps.
Unzip the attached file, ToadTask.zip.
Double click on the file: patricia.swf.html to run the patricia.swf file.