question

ShubhamDhumal-1406 avatar image
0 Votes"
ShubhamDhumal-1406 asked PramodValavala-MSFT answered

Execute pipeline at specific time which is store in sql db?

I have one pipeline and I need to execute this pipeline at a specific time. this time is specified in SQL database

azure-data-factoryazure-sql-databaseazure-functions
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

This functionality is not available right now in ADF. But there is Event based trigger available, where any file is created/modified in Azure storage, pipeline gets created automatically.

Not so good workaround - you may think of writing a file to storage as soon as you update date in SQL, this way,, pipeline will get trigger after file creation


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PramodValavala-MSFT avatar image
0 Votes"
PramodValavala-MSFT answered

@ShubhamDhumal-1406 Another workaround you could consider would be to leverage Azure Logic Apps to trigger the ADF pipeline using its available connector's actions.

You could simply use the recurrence trigger instead of the SQL Entry or you could design a logic app workflow that reads the SQL Entry and sleeps accordingly in a loop.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.