Unreliable Scheduling

  • 34Views
  • Last Post 13 February 2023
0
votes
Shea Anderson posted this 09 February 2023

Our scheduled replications do not seem to reliably run on schedule.  A good example to look at is our "OASIS-SQL" package.  It is scheduled to run every hour.  It never runs precisely on the scheduled time, deviating by some minutes each run, but that is acceptable.  Sometimes it skips an hour and runs every two, instead.  That is also, in this case, acceptable, though not optimal.  The real issue comes when it seems to skip large chunks of runs.  As an example (and there are several in history), on February 8th, only one run occurred.  The package ran at 1:08:44 AM (Run ID 122489817) and then the next run is currently happening at 2023.02.09-12.21PM (Run ID 122499958).  How do we get to a point where this can be more dependable?

Order By: Standard | Newest | Votes
0
votes
Serhii Muzyka posted this 10 February 2023

Hi Shea,

 

Thank you for contacting Skyvia Support.

 

We see that your last run has not been finished and you are currently cancelling it. After analyzing your logs, we see that the same situation happened on January 30th. The package was running for 22 hours and fell with A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable) error. See more about the error here.

Because it took 22 hours for execution, it skipped all the scheduled runs. It's possible that the same error would have occurred today too.

For this situation, we can recommend switching from the direct SQL Server connection to using the Skyvia Agent.

Skyvia connects to the database server via a secure Agent application. You create an Agent, download and install the Agent application on a computer that has both Internet access and access to the database server. Data is securely transmitted between the Agent and Skyvia in an encrypted form, and it doesn’t require a dedicated external IP or port, and usually does not require an additional firewall configuration.

See more here: https://docs.skyvia.com/connections/agent-connections.html

 

Please try and let us know if it helps. 

 

Best regards,

Serhii

0
votes
Shea Anderson posted this 10 February 2023

If we change to using an agent, can we simply modify the existing package without concern for loss or duplication?

0
votes
Serhii Muzyka posted this 13 February 2023

Hi Shea,

 

We hope you are well!

 

Yes, you can use and modify the existing package, it will not affect it. 

 

Should you have any other questions, don't hesitate to reach out.

 

Best regards,

Serhii

New Ticket
Categories
Popular Tags
Close