Issue with transfer

  • 12Views
  • Last Post 2 weeks ago
0
votes
Ray Scott posted this 3 weeks ago

Hi I have an issue where i am sending several tasks in a package Salesforce --> SQL

then I have a second package running SQL -> salesforce that cheacks a flag in salesforce

the package does not always run in time (they are schedualed every 5 minutes)  sometimes they are queued for up to 20 minutes   

what happens is the first package may run twice before the second package runs sending duplicate data

is there a way to trigger the second package to run when the first finishes?  or is there a way to add a step in the first package to write the other direction

STEPS 1 to 5 Salesforce to SQL

Step 6 SQL to Salesforce

 

Please let me know

 

SendQuoteToVista

 

   

0
votes
Dmitriy Muzurov posted this 2 weeks ago

Dear Ray,

Thank you for submitting a ticket with us.

As we advised previously for such scenarios the time difference between packages runs should be around 20 minutes to cover possible issues with standing in queue.

Please increase the time difference and configure the first package to comply with this, i.e. run at certain o'clock once an hour.

Unfortunately, there are no triggers or trigger-like functionality in Skyvia yet.

We are looking forward to hearing from you, should you have any questions.

Close