2. Automated Backup
Backups help ensure, that your files aren't permanently lost or damaged.'Automated Backup' or 'Script Execution' tool serves for performing database backup or run SQL script based on a specified schedule, thus to save your time and be able to protect your database from possible disruptions.
Use this section toolbar to perform the following operations:
- press 'Create or Modify Configuration' button to launch backup wizard and configure backup settings (see the chapter about Backup / Restore Database);
- if you have already configured the backup configuration, you may choose it from drop-down list next to the 'Configuration' field and click on the 'Run Backup' with current configuration button;
-add selected backup configuration to scheduler.
Open the scheduler form where you can see the main parameters for settings:
- task scheduler name - choose from drop-down or type manually;
- task type - this field is not active for the user editing and is filled by default
-task-configuration - select the configuration name which you will be used for automated backup
- specify the time period when this backup will run, i.e. daily, weekly, monthly and at once.
- depending on the period, you have chosen, complete the following fields:
а) start time of the procedure with the specification of the particular day;
b) the start time of the procedure and the particular day of the week;
c) the start time of the procedure with indication of particular day of the month:
d) the start date and start time of the procedure:
You can configure in additional the repetitive task which is the bottom of the form by selecting the checkbox next to the appropriate field and assigning the periodicity of this process.
Scheduled task list is a list of tasks stored in your Windows scheduler. You can call it by using the appropriate button in the backups toolbar:
To open scheduled tasks list in your Widnows OS go to Addons -> choose Show Scheduled Tasks option.
In case you need to run SQL scripts frequently, Automated Script Execution option will be useful for you.
NOTE!: Do not run Script, if you are not sure, that SQL is working properly and will not corrupt your database.
In this section you can find Automated Script Execution settings, which allows you to perform following operations:
Click “Create or Modify Import Configuration” button to run Wizard and configure settings:
If you have already configured the restore database configuration you can choose it from the drop-down next to the 'Configuration' field and press 'Run Script' button:
Click on "Add Current Script Execution to Scheduler" button to specify task name, time and frequency.
Show scheduled tasks option. Here you can find your task to restore your database along with other windows tasks performed regularly.
By using the top toolbar you can add or delete task, see properties, refresh list and run task: