ADF trigger: Pipeline has to trigger every December on second Friday from end of the month.

Question

ADF trigger: Pipeline has to trigger every December on second Friday from end of the month.
A pipeline has to trigger every December on second Friday from the end of the month. I am trying to do this using scheduled trigger of ADF by using,

• Start date of Dec 1st 2021
• Recurrence of 12 months
• No end date
• Advanced recurrence option of weekdays with occurrance as -2 and day as Friday. "name": "Dec_Last_But_One_Friday",
  "properties": {
  "annotations": [],
  "runtimeState": "Stopped",
  "pipelines": [
  {
  "pipelineReference": {
  "referenceName": "pipeline_test_triggers",
  "type": "PipelineReference"
  }
  }
  ],
  "type": "ScheduleTrigger",
  "typeProperties": {
  "recurrence": {
  "frequency": "Month",
  "interval": 12,
  "startTime": "2021-12-01T14:24:00Z",
  "timeZone": "UTC",
  "schedule": {
  "monthlyOccurrences": [
  {
  "day": "Friday",
  "occurrence": -2
  }
  ]
  }

Is this right way? how do I know it will be definitely trigger every year, the Second Friday from the end of the December month. Is there a way to see the future schedules in ADF?

Thank you!

Answer 1

Hello @Naresh E and welcome to Microsoft Q&A.

As far as I can tell, that looks correct, I think.

At this time I am not ware of any "predictive calendar" feature in ADF, but you are not the first to ask about it, I think it would be a wonderful addition, as I agree the triggers can be somewhat confusing. Please upvote in the feature forum. The more demand is visible, the more likely it will be implemented.

I would recommend creating another trigger for testing, similar in structure, but aimed for a much closer date in the future.