CODEWITHSUNDEEP
azure-synapse
Rajib
Rajib

Reputation: 29

Create schedule job SQL Datawarehouse

We are using polybase to load data from azure blob storage to Sql Datawarehous. How do we scheduling job so that that that can be updated regularly without manual effort?

Upvotes: 1

Views: 1033

Answers (1)

Alain Dormehl MSFT
Alain Dormehl MSFT

Reputation: 51

What I normally do is, I use the Job Agent on one of my on premise or Azure based SQL Box installations to schedule the execution of stored procedures in either an APS or ADW.

Alternatively if you are looking at a fully end to end PASS solution, I would say look at Azure Data Factory.

You can look at this article for an example how to use ADF : https://azure.microsoft.com/en-gb/documentation/articles/data-factory-stored-proc-activity/

Upvotes: 4

Related Questions