Toad Automation

ds_texas_515 · October 28, 2011, 10:23am

Can the user supply a variable to a toad automation script using. Such as using the set variable.

Guest · October 28, 2011, 10:23am

Hello

Yes, Toad’s automation designer has the following actions available to be built
into Toad automation scripts, or apps: create variable, set variable, test
variable, variable prompt. A lot of Toad features which can be automated also
support variables. For example, if you’re automating a data export, open your
export dataset action and r-click in the “file” edit box and select “variable”

-Brad

ds_texas_515 · October 28, 2011, 11:44am

I saw the 3 different items that reference variables, However they don’t provide a way to add my own variable, such as I have a variable named “DATE_DIR” I cannot seem to find a way to add this to the optional variable list.

Guest · October 28, 2011, 11:44am

Which version of toad are you on?

Are you referring to the User Variables list in Options > Variables?

ds_texas_515 · October 28, 2011, 1:43pm

Version 10.6.1
the set variable gives two option rman_log_location and rman_backup_location
the variable prompt gives the same options
The test variable has an additional 14 items such as user, pw and DB

Where can I add my date_dir var

ds_texas_515 · October 28, 2011, 1:45pm

All of this is part of the automation designer

Guest · October 28, 2011, 1:45pm

The set variable and variable prompt actions only supports user-defined
variables

Thanks,

Brad

matt.wilkins · October 28, 2011, 1:45pm

And keep in mind that you can create your own variable based on any of the
existing system variables defined in options. Example:

User variable MYDAY = system variable %DAY%

ds_texas_515 · November 1, 2011, 1:39pm

Thanks Brad. I got it.