I created an App that consists of 6 Export Dataset queries. They should dump the results into a .mdb database. These work correctly when I run them individually.
When I attempt to schedule this App within Toad to run at a specific time, it does not work properly. The Execution Log will show that they ran at the selected time, but the .mdb does not show the results.
I’m curious if the problem exists within the Action tab of the scheduler. The Action is currently set to ‘Start a program’, which is Toad.exe. Should the 6 queries that the App consists of also be in the Action list?
I figured that since I was right-clicking on the App itself to even get to these scheduling screens, that those 6 queries were part of the task I was scheduling.
Can anyone help?