How to schedule jobs in Pro2

Pro2 is primarily used for replicating and synchronizing selected data and database objects from a source database to a target database. You can choose to manually perform your replications or schedule them to replicate automatically.

You can also schedule a variety of jobs by using the job scheduler. The job scheduler enables you to schedule recurring replications, CDC tasks, file purges, log checks, and more so that you no longer need to perform these tasks manually. For detailed descriptions of the types of jobs available, see Types of scheduled jobs in Pro2.

To schedule a job:

1. From the Actions tab of the side menu, click Jobs > Scheduled jobs > New.

   

2. Under the Type drop-down list, select the one of the following job types:
   • Applied Queue Record Purge
   • CDC Purge
   • CDC Threads
   • Enterprise Push
   • File Purge
   • Replication Log Check
   • Replication Threads
   • Replication-CDC Threads
   • Status Check
3. Enter a Description for the job. A description helps you differentiate between similarly scheduled jobs.
4. If you are creating a new job, then ensure that the Enable check-box is selected. If you want to disable a scheduled job, but not remove a scheduled job, then you can do so by using this check-box.
5. In the Settings section, choose the job's start and end date as well as the start and end time.

   You can schedule a job to occur once, daily, weekly, or monthly depending upon your business needs.

   If the job is scheduled to repeat monthly, you can indicate the start date, end date, start time, end time, the month or months to repeat on, and number of days per month.

   Note:

   • In order to schedule a job once, select One Time from the Settings section and provide the start date and start time only. The default values for the Start Date and Start Time fields are the current date and time, respectively.
   • To schedule a job daily, weekly, or monthly, you need to provide the end date and end time, along with other parameters. By default, the End Date field is blank and the End Time is 11:59 PM, or 86340 seconds past midnight.
   • For the monthly frequency, if you leave the Perform the job on day(s) of the selected months field blank, then the job is scheduled for the day it is presently for each of the selected months.
6. Set the Repeat task every field.

   Use this field to indicate when the job should be repeated. You can set the number of hours or minutes. This field is dependent on the repeat cadence. For example, if the job is scheduled to repeat daily, set this filed to 0 to repeat the job once per day.

7. Click Save.