Hello @Arundhati Sen, Your approach looks good, did you face any issues in the Schedule?
As i have also verified this info on Scheduling, seems it is not available out-of-the-box as of now,
But we can certainly use combination of Triggers schedule and then Skip the Run in the Pipeline if the current day is a weekend instead of weekday, please do let me know if the below answer helps!
Azure Data Factory doesn't directly provide a way to exclude a specific time (like 2PM). However, you can do it indirectly by setting multiple schedules within the same trigger for different time slots (4AM to 12PM and 4PM to 10PM).
- You'd create a second trigger for daily execution. This can be a Schedule Trigger that recurs daily and is scheduled to run at 2PM.
{
"name": "DailyTrigger",
"properties": {
"runtimeState": "Started",
"pipelines": [
{
"pipelineReference": {
"referenceName": "<your-pipeline-name>",
"type": "PipelineReference"
}
}
],
"type": "ScheduleTrigger",
"typeProperties": {
"recurrence": {
"frequency": "Day",
"interval": 1,
"startTime": "2023-01-01T14:00:00Z",
"endTime": "2023-12-31T14:00:00Z",
"timeZone": "UTC"
}
}
}
}