how to skip pipeline run on holidays

[saikoneru1997]

Here we need to use predefined calender table in azure sql db

Then use lookup activity to get current date status like below

select status from table where date_column=current_date and pipeline_name='soandso'

here we can get status='working' or status='Holiday'

after lookup use if else activity use equals('Working',lookup.activityoutput.status) - functions

if true then execute the pipeline else not execute the pipeline

to this pipeline we can apply schedule trigger which runs every day