CODEWITHSUNDEEP
azureu-sql
Vanamali
Vanamali

Reputation: 47

Automatic/Scheduled Daily USQL Script Execution

I have several Azure USQL scripts that I want to run through a daily job at a fixed time. What options I have?

I want to execute each .usql script every day. How can we automate it?

Thank you

Upvotes: 0

Views: 77

Answers (3)

Vijay Kumar Sharma
Vijay Kumar Sharma

Reputation: 397

but, sometimes we need to automate the execution of pipelines, for this purpose we use the trigger to schedule a specific time on which our pipeline must be execute, you are correct when we need to execute a no. of pipeline but sometime we had a lot of pipelines that execute simultaneously one after another, so we use trigger and also it can be run through .json, python, .net and on the power-shell.

Upvotes: 1

Vanamali
Vanamali

Reputation: 47

Lot of people were suggesting the use of the Data Factory. But, the following seems to be working fine for me.Not sure, if there is any issue with that. 1. Created and placed all the USQL scripts in a local folder. 2. Created a PowerShell script to execute these USQL scripts using the Azure Powershell addin. 3. Scheduled the job using the Windows Task Manager to execute this powershell script on a schedule.

Upvotes: 1

Vijay Kumar Sharma
Vijay Kumar Sharma

Reputation: 397

Please go through the scheduling trigger as given link, according to your specific time options

Upvotes: 0

Related Questions