If you’re only entering the script file name as the target of the “Start a program” action, it will most likely only attempt to open the script using the default application. If no default application is defined, or if the process running the task doesn’t have access to that application, Windows could easily display that response.
What are you trying to do with that script file? Are you trying to execute it at pre-scheduled times? If so, I would create a new “Execute Script” task in the Automation Designer and schedule it, as in the following:
- Open Toad and log into the database you want to execute the script against
- Open the Automation Designer
- Go to the DB Misc tab and add an “Execute Script” action.
- Double-click on the action to edit its properties and add the script file in question. Select your output options.
- Click “Apply” and then close the properties window
- Right-click on the “Execute Script” action you just created and select “Schedule…”.
- Toad will automatically add the correct action to the Task Scheduler wizard, so you can simply click next and select your triggers when the action should be run.