Query link on desktop

Toad for SQL Server
1

Hi everyone,

I have just a simple question.

I have a query that i needing several times a day. It is an advantage if i could make a desktop icon, which makes the quary automatically, so i dont have to start toad each time.

I hope you can understand my Problem and I am sorry for my bad english.

Thank you.

Message was edited by: Xplosio

2

Hello,
I’m not 100% sure what do you expect as a result, but it seems to me you can get it with creating Toad Automation file and make a Windows schedule that you can run any time you want.
So, basically you have to perform these steps:

  1. Create sql file you want to execute
  2. Create Automation task (Tools\Automation) with using the file (Execute script activity in Automation)
  3. Test it inside Automation - Run Automation script :slight_smile:
  4. Create a schedule that you can run manually any time without starting Toad for this.

Hope it is what you need.