I would go into the Task Scheduler under Utilities -> Task Scheduler. Double-click on your task to edit it. Then, go to the “Triggers” tab, select the desired trigger and click the “Edit” button. That should allow you to change how the task is triggered.
thank you for you help, but this is the way how I create the task the problem is that then it does not work/run it in automatic and if I run it manually from atsk scheduler it is the same, so I guess something I do i wrong but I don’t understant what.
Help Help Help and of course thanks in advance for it
Can you provide some step-by-step detail about what kind of task you’re trying to set up and how you’re doing it? I just tried creating a basic tasks using Toad 13.0. I’ll outline my steps here in case it helps at all:
I opened Task Scheduler
I clicked on the button to create a new task, which launches the wizard
I entered a name for the task and clicked Next
On the actions page, I clicked “New”, chose “Display a message” (for my test) and entered a title and message. Then clicked “OK” and “Next”.
On the triggers page, I clicked “New”, left the option as “On a schedule”, chose “One Time” and set a time. I also made sure “Enabled” was selected and clicked “OK” and “Next”.
I then clicked “Next” again at the login page and entered my user credentials.
I then clicked “OK” to finish.
At the specified time, a dialog popped up as expected and showed me my message. This is just a very basic test, but it follows the basic process. Are you performing different steps when you create your task?
Yes, the “Display a Message” and “Send an e-mail” task actions were deprecated by Microsoft in Windows 8 and higher. I was merely using that as an example. You can still create a “Start a program” task if you’d like to do a test. Simply replace step 4 above with “Start a program” and pick something simple like “Toad.exe” or “Notepad.exe”. Then, continue with step 5 above.
tried with notepad and it works, then I tried again using SQL script (abd.sql) instead of notepad.exe and does not start, putting on LAST RUN RESULT “operation cancelled by the operator”.
Is is something with file format (.sql)?
I really don’t understand
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.