Share via

How to avoid concurrent event based triggered pipeline execution in azure synapse

Jakeer Shaik 106 Reputation points
2022-07-13T13:43:11.337+00:00

Hello,

I am trying to avoid concurrent execution of event based triggered pipeline runs to make sure only one trigger is executed end-to-end.

Basically when a trigger is running, if the same trigger kicked off again then it should check the status of the triggers running and if the same trigger is already running then I need to stop the current trigger and let the previous trigger run.

Any help would be really appreciated.

Thanks,
Jakeer Shaik

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments

Answer accepted by question author

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator
2022-07-13T16:19:55.85+00:00

Hey,
You can use concurrency option

220370-image.png

That should enable only 1 run to be active for a current period of time and other would go into queue as per my understanding.

Please do test it out once :)

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jakeer Shaik 106 Reputation points
    2022-07-14T12:04:45.537+00:00

    @Nandan Hegde , it worked as expected. However, would you please tell me is there a way to get the list of pipelines which are currently running.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.