Replication Frequency is a type of replication scheduling that runs replication jobs based on a time interval you specify.
In this guide, we’ll cover:
Replication Frequency availability
Replication Frequency is available for all database and SaaS integrations.
How Replication Frequency works
The Replication Frequency setting, found in the Integration Settings page, defines how often Stitch will attempt to extract data from an integration. For example: If set to 30 minutes, Stitch will attempt to connect to and extract data from the integration every 30 minutes.
Initial (historical) replication jobs
After you define and save the integration, Stitch will update the integration’s Sync Status to Pending. This status indicates that Stitch is in the process of scheduling a replication job for the integration.
Note: For newly created integrations, scheduling a replication job can take up to 30 minutes. You can also manually start a job, but note that this will determine how ongoing replication jobs are scheduled.
Ongoing replication jobs
Ongoing replication jobs are scheduled based on the start time of the previous job.
If a job runs over into the next recurrence of the selected Replication Frequency, it will be skipped. Jobs will resume at the next Replication Frequency interval. Refer to the next section for an example.
Example schedules using Replication Frequency
Example 1: Schedule using a 6 hour Replication Frequency
In this example, we’ll look at the potential schedule for an integration with a Replication Frequency of 6 hours.
Based on these settings, Stitch will kick off a replication job every 6 hours. The schedule for this integration might look like this:
|Job #||Start Time (EST)||Start Time (UTC)|
Example 2: Long-running and skipped jobs
In this example, we’ll look at how a job can be skipped due to a previously long-running job. This can occur when a job takes longer to run than the selected Replication Frequency.
Based on these settings, Stitch will kick off a replication job every hour. The schedule for this integration might look like this:
|Job #||Start Time (EST)||Start Time (UTC)||End Time (EST)||Duration|
In this example, Job 3 (scheduled for
04:30:00) was skipped because Job 2 took longer than the Replication Frequency (1 hour/60 minutes) to complete. Replication then resumed on the next recurrence of the Replication Frequency, which was at
Note: Stitch doesn’t currently send or display notifications when a job is skipped.
Create an interval schedule for an integration
You can create an interval schedule using Replication Frequency in an integration’s Settings page.
- To access this page, click the integration from the Stitch Dashboard and then click the Settings tab.
- In the Replication Frequency section, uncheck the Use integration default checkbox.
- Using the slider, select the Replication Frequency interval you want the schedule to use.
- When finished, click the Save Integration button.