Scheduling of Database Migration tasks

The best way to keep your databases up-to-date and launch sync or migration jobs regularly is to use Built-In Scheduler. It is available for all synchronizers and converters listed at our web site.

Scheduled jobs with sessions and batch files as parameters are launched as services running in background. Scheduler allows keeping migration tasks unattended and executes them automatically at specified time or a particular period of time.

Easy-to-use wizard interface helps to set up scheduling process with minimal efforts to save hours of routine work.

Scheduling Database migration

Follow these simple steps to set up scheduling process:

Scheduling stage

Clicking the “Scheduling button”, as shown on picture below, opens up opportunities to add, edit and remove scheduling tasks to be executed at specified time.

Built-In Scheduler Database migration

Add new task

Click on the "Add" button to put a new scheduled job in the list of executed tasks. "Add new task"dialog appears where you can specify additional parameters.

Add new task

In the "Session" tab enter a name for a task in "Task name" field which describe it the best.
Select desired application from "Application" list to be launched. An application itself is chosen by default.
Specify previously saved session or a current one at “Session” field.
"Running file" field keeps the path to an executable bat file.

Add new task fields

Click “Ok” button to save settings.

Edit scheduled task

Press "Edit" button to edit the currently selected scheduled task. Or you can double click a task at listbox. Specify task settings in "Edit task" dialog box.

Edit scheduled task

"Triggers" tab contains fields for setting up triggers conditions specify the triggers conditions for each task. Read more information about triggers adjustments

You can add notes/ description for each scheduled job at the "Settings" tab. This information will be shown in the main window.

The next fields are requiered for proper scheduling process. Otherwise your task won't be executed. Enter your user login and password for Windows system into the fields "User name" and "Password". Repeat your password at "Confirm password" field

Edit scheduler settings

Trigger Settings

Our built-in Scheduler launches migration jobs using triggers specified in "Trigger settings" dialog. You can setup triggers to start tasks depending on definite date and time in any combination.

Use "New" and "Delete" buttons to add new triggers and remove unnecessary ones accordingly.

Please Note that New triggers can be added not only for new tasks but for the already existed ones as well.

Each scheduling task has its own execution status showing what currently happened or should happen with selected task. Here is the list of possible status messages:

  • Task is running - selected task is currently executing
  • Task is ready - the task is ready to be launched at the next scheduled time
  • Task has been disabled - the task will not be launched at the specified time because as it has been disabled
  • Task has no more runs - there are no more runs scheduled for this task
  • Task has not been run - the task has not been run by some reason, even if the task will be launched at the next scheduled time or the task is a recurring one
  • Task is not scheduled - the trigger is not specified
  • Task has no valid triggers - the task has no triggers or the existing triggers are disabled or not specified.

Certain time and/or date can be specified for Triggers running at. Below there are some examples showing variety of ways for Triggers setup:

1. Once

Specify a particular date and time for a task to be executed once. Choose "Once" option from the "Schedule task" drop down list.

once trigger setting

2. Daily recurring

This option arranges a day to start/ finish a task recurring set to be executed once or several times at a specified time. Choose "Daily" option from the "Schedule task" drop down list. Customize other options like "Start time" and "Every... day(s)".

daily reccuring

"Advanced" button opens up additional options for a current task.

"End date" option means for specifying the end date of the task execution.

Check "Repeat task" option to define the exact task duration.

If the previously specified job is still running you can check an option to stop it compulsory using this option "If the task is still running, stop it at this time" check box.

daily reccuring advanced

3. Weekly recurring

A task will be run on weekly basis on the definite day of a week at the specified time. Choose "Weekly" option from the "Schedule task" drop down list. Customize options "Start time" and "Every... week(s)" in this dialog.

weekly reccuring

Advanced settings for weekly recurring are completely the same as they are for Daily recurring.

4. Monthly recurring

A task will be executed on monthly basis on the specified day of the month and at the specified time. Choose "Monthly" option from the "Schedule task" drop down list. Customize other settings as shown below.

monthly reccuring

monthly reccuring

Remove Task

Press "Remove" button to remove a task if you don't need it anymore.

remove scheduled task

comments powered by Disqus