Return
-
Title
Can Toad for Oracle automate the process of opening a script, running it, saving the output to Excel file, and scheduling it? -
Description
Can Toad for Oracle automate the process of opening a SQL script file, running it, saving the data results output to an Excel file, and then scheduling it?
-
Resolution
RESOLUTION 1:
Toad for Oracle does not have a functionality that can open a .SQL file, run it, save the data output results in an Excel file, and then schedule it to run automatically.However, the workaround below may work. You will need to manually plug-in your SQL query statement script in the GUI itself.1) Go to Utilities | Automation Designer.2) Under ‘Import / Export’ Tab | use the “Export Dataset” icon (4th icon).3) Open that icon | choose “Excel File” under ‘Export Format:’ | then assign a filename for it already.4) Next, go to the “Dataset” Tab | paste your SQL query script there (Note: you may need to remove the ending ‘semi-colons’ as that seems to invalidate the SQL statement. For example, remove the “;“ in “select * from emp;“).5) Click Apply | click OK | click Run to test it.6) If that runs as you expected, you can now right-click that Activity and choose “Schedule”, and then follow the wizard to complete its automation. The Scheduled Task gets saved in Windows Task Scheduler.RESOLUTION 2:
Quest has another product called Toad Data Point that can do the above said functionality.
RESOLUTION 3:
We value our customer’s needs and every Toad version is created and designed with many user inputs in mind. Please visit the Toad Idea Pond to log an enhancement request for this feature. This site is solely dedicated to tracking customer enhancement requests and allowing the user community to vote on the most useful feature. The Development Team personally monitors this website and provides customer feedback on their enhancement requests.