Automated task does not create expected output file and email when scheduled. No error is given, but the job notes that it starst up and runs.
The task can be manually run in Toad and the file and email are created and sent. But when it's scheduled and/or run manually though Task Schedule, it does starts up but does not run as expected.
Connection is failing. This error/failure is not noted in Task Scheduler or in Toad's gui. But it is noted in Toad's automation log file.
C:\Documents and Settings\<pesronal folder>\Application Data\Quest Software\Toad for Data Analysts <version>\Automation\Script_1.log
When in Toad's connection window, make sure to save connection password in general. A created automated task pulls the connection info from Toad's connection files (connections.xml). If the connection password is not saved, the task will not be able to access the database on it's own later.
It runs manually within Toad because a connection to that database is already made. But when run through scheduler, it opens a new session on it's own and then needs the password.
Keep in mind the connection info that the automated job refers to is in TDA's Connections.xml file. If this file or the general connection info to a particular database/login is changed, this can affect the automated jobs that refer to it.