Go to Toad menu | Utilities | Automation Designer
Steps:
a. How to create a new app in Automation Designer
- Go to My Apps | Default option | right click | select 'new app' | The default name is App1
- 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.
b. How to create the Zip file
- 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)
- Right click and select Properties | In the upper left corner, first button, click on the dropdown arrow and select 'Add Folders'
- Add the path to backup. For example, for Toad for Oracle 13.x go to :
C:\Users\ [Windows User] \AppData\Roaming\Dell\Toad for Oracle\13.x - Enter the path where the zip file will be located in Zip filename, e.g. in C:\Toad Backup\ToadProfile.zip
- Click on 'Run' and Automation Designer will run this job for you.
c. How to schedule it
- 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
- 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.
