Hi - I have some script that I would like to run daily. I try to schedule it but some reason it is not working.
Please advise!
Thank you,
TOAD user
Details please.
Not working = ??
e.g. an error message? Is the error in the script? in the Editor? In the automation job?
Please explain Toad's response
Schedule some script to run daily = ??
By what means? via the Automation Engine? via Toad command line?
Version of Toad?
Windows version?
You'll get better response from forum users with details please.
Hi Gary
Thank you for your time and response my concerns
I have toad version 6.1.2.24(64bit)
Windows version 11 pro
I have a sql query I automated via toad and working fine and results goes to shared folder
But I want to run daily without having me login into toad
So schedule a script daily and enter password and closed
But next day - I don’t see any results or any error message, nothing
So my question is:
How should I do it?
Do I need special permission in order to this works ?
Or
May be I am not doing right
Please advise
Kind regards,
Dalpat Mistry
First of all, upgrade your Toad for SQL Server. latest release is 8.1, and the version you have is at least 5 years old.
Secondly, you can create an "automation job" that executes a task called "Select to File" (or something like that... not at my Toad station at the moment.) That task allows you to execute a script or query, and then export results to a flat file or other file type. The Automation job can be scheduled to run unattended by your Windows Task Manager.
Toad's product Help should give you sufficient details on using the Automation Designer.
Also, don't be afraid to search for/view helpful videos on the topic right here at ToadWorld.com. Here's a few you might find useful: