Import records modified between specific hours

  • 15Views
  • Last Post 4 weeks ago
0
votes
Marina Seredova posted this 4 weeks ago

Can we schedule jobs so that we can import records modified between 10 AM and 2 PM everyday ?

Or similarly, import records which have been modified since yesterday 8 PM

Order By: Standard | Newest | Votes
0
votes
Simon Bubnov posted this 4 weeks ago

Skyvia does not have relative constants for such periods.

Can we schedule jobs so that we can import records modified between 10 AM and 2 PM everyday ?

It's not possible to implement such scenario via Skyvia.

Or similarly, import records which have been modified since yesterday 8 PM

You can schedule the package to run every day at 8PM and set filter to process only records changed after the last package run. It can be done with LAST_RUN relative constant or with the State Filter - Updated. For more information, please refer to https://skyvia.com/resources/docs/index.html?importing_recently_added.htm

0
votes
Marina Seredova posted this 4 weeks ago

Or can we set up job to import only records changed in last 6 hours ?

0
votes
Simon Bubnov posted this 4 weeks ago

Unfortunately, there is no such possibility.

You set up scheduling for running your package every 6 hours and set filter to process only records changed after the last package run.

Close