How to create a backup job in Toad for Oracle using Automation Designer, in order to have a backup copy of Toad settings, preferences, scripts, connections and passwords.
Go to Toad menu | Utilities | Automation Designer
1. How to create a new app in Automation Designer
a. Go to My Apps | Default option | right click | select 'new app' | The default name is App1
b. Once you have App1 (Toad will create this automatically as App1 or App2 depending if the App1 was already created) | Right click on it and rename it as, for example, 'Backup'. This will be the application name.
2. How to create the Zip file
a. Go to Utilities tab | Click on Archive, this will create the file Archive1| right click on it and rename it as Toad_Bak (This will be the name of the zip file)
b. Right click and select properties | In the upper left corner, first button, add the path to backup, in this case for Toad for Oracle 12.x go to :
C:\Users\ [Windows User] \AppData\Roaming\Dell\Toad for Oracle\12.x
c. Enter the path where the zip file will be located in Zip filename, e.g. in C:\Toad Backup\ToadProfile.zip
d. Click on 'Run' and Automation Designer will run this job for you.
3. How to schedule it
a. Go to the application name, in this example, 'Backup' and right click on it | Select Schedule | Toad will open the 'Schedule Toad Action Wizard' window
b. Enter the name of the task you want to schedule e.g. Backup_task | Enter a description like : "This task provides a backup of my Toad connections and templates, it runs everyday at 10.00 am PST". | Click Next | click 'New' to continue with the wizard and specify the conditions that will trigger the task e.g. , Automation Designer will run this job daily, weekly or monthly| Select the time | Click 'OK' and Click 'Next' | Define if this job will run only when the user is logged on or not | Click Finish | After this last step, you will have created the schedule task.
The backup job will be properly configured when you have done these 3 steps.