Schedule a Quey

  • 26Views
  • Last Post 27 October 2021
  • Topic Is Solved
0
votes
Rob Mosavi posted this 26 October 2021

I need to schedule a query to run automatically daily. The Query is:

 

update Products  

set SortOrder = (InventoryLevel * -1)

 

and it's to a BigCommerce connection. 

 

How would I do this?

Order By: Standard | Newest | Votes
0
votes
Olena Romanchuk posted this 27 October 2021

Hello Rob,

To perform the update operation against the target field, you can use Skyvia Control Flow Simply add the Action component to the flow, select your BigCommerce connection, select the Execute Command action and paste your query to the command field. Then you can set the schedule and the Control Flow will run according to it. More details on Control Flow is available here https://docs.skyvia.com/data-integration/control-flow/how-to-design-control-flow.html  
Please revert to us if any further assistanse is needed.

Best regards,
Olena Technical
Support Engineer 

0
votes
Rob Mosavi posted this 27 October 2021

Olena

 

Thank you for the quick response, I believe this is exactly what we're looking for. Thank you again! 

 

-R

0
votes
Rob Mosavi posted this 27 October 2021

Thank you! 

Close