This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
How can I schedule a trigger pipeline in Azure Synapse analytics to run every 30 minutes, but avoid starting when another pipeline is running or at certain specified times (such as between 1 am to 3 am)? I am seeking guidance on the best approach for scheduling this pipeline.
There is a property called concurrency to avoid multiple runs of the same pipeline at same time.
Thanks @Nandan Hegde ,
I have 2 different pipelines and the pipeline which is schedules to run every 30 mins I want to disable the for specific time let say between 1 am to 3 am
Can you plz share what is your current trigger configuration?
Because there are diff ways to handle your ask
@Nandan Hegde ,
First trigger configuration
Second trigger every 30 mins,
where Max concurrency = 1
one way would be to create 2 triggers mapping to the same pipeline :
and the another one would be hours:3 and mins :30 to cover the 3:30 AM scenario.
Other way would be to have the current trigger as is but at the start of the pipeline have condition to chcek whether the trigger time is between the no trigger zone, then you can skip the pipeline proceedings else proceed as is