Import records modified between specific hours

  • 21Views
  • Last Post 19 September 2018
0
votes
Marina Seredova posted this 18 September 2018

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 18 September 2018

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 19 September 2018

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

0
votes
Simon Bubnov posted this 19 September 2018

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