Command_Line

No. Quest Central does not support the TOAD command line options.

For any of the windows that support command line execution:

1. Go to the window and set your options as if you were going to run the window now.
2. Click the "save settings to file" button (floppy disk icon).
3. Open up the file you just made with Notepad. There are directions in it on how to do the rest:
   1. The directions show how to call TOAD from the command line with this options file.
   2. If you want TOAD to close after it runs, uncomment "CloseTOAD"
   3. Depending on which window this is, there may be other things you need to specify, and they are described in this file.
   4. If you want this to run nightly, you can make a batch file with the appropriate command and then schedule it with your Windows scheduler.

If you want to use the command line with the network install, then you will need to add the path to your client directory into the command. For example, instead of using this to run the health check:

"c:\toad\toad.exe" Connect=system/manager@mydb HC=c:\thisfile.txt

You need to use this (where the network server is at "H:\toadserver" and the client is in "c:\toadclient"):

"h:\toadserver\toad.exe" PATH=c:\toadclient Connect=system/manager@mydb HC=c:\thisfile.txt

The following windows can save settings files that tell you how to run them from the command line:

• Analyze All Objects
• Compare Databases
• Compare Schemas
• Database Health Check
• HTML Schema Doc Generator
• Generate Database Script
• Generate Schema Script
• Rebuild Multiple Objects
• Save As (Save Grid Contents)

There is also a command line option to run a script:

"toadpath\toad.exe" CONNECT=user/pwd@database filename /EXEC

where

• "toadpath" is the directory path for the TOAD executable
• "filename" is the name of the script file

Note that Quest ScriptRunner (QSR) can also run scripts from the command line. It uses the same syntax as SQL*Plus for this:

"qsrpath\qsr.exe" user/pwd@database @filename 

where "qsrpath" is the directory path for the QSR executable. If your script contains an "exit" command, then QSR will close as soon as it is finished.