Is it possible to create multiple schedules for a single Sync job?
The use case here is that I'd like to run a job only once per day on some days of a month but then multiple times per day for some other days.
One idea that comes to my mind is that I can create two jobs with different schedules, but the problem here is that if a destination table is incrementally synced (which is required for large tables), two jobs will not be able to coordinate.
Hi
In order to accomplish what you are looking for you' may want to make use of Cron expressions when configuring the scheduler. However you will still need to create two separate jobs with the same configuration and set the desired schedules as there is no way to configure two different expressions in the same job.
You can read more about that, and see examples of these expressions in the Sync documentation here:
https://cdn.cdata.com/help/ASK/sync/Scheduling-Jobs.html#using-unix-cron-syntax
As for your concern, please keep in mind that the incremental status is identified by a combination of the source/destination/query. The incremental status should normally be the same for both of the jobs so as long as the jobs are not running at the same time you there should be no issues with the data syncing in the destination table.
If you have any further questions feel free to reach out to the support team at [email protected] and one of our Sync support specialists will further assist you.
Hello
Your answer is really helpful! Thank you! The most encouraging part however is the following!
the incremental status is identified by a combination of the source/destination/query. The incremental status should normally be the same for both of the jobs
I do not intend to change the query across these jobs anyway, just run them with different schedule, so I think it should work?
Yes, it should work.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers