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

Naresh E 121 Reputation points
2021-04-26T07:45:26.547+00:00

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,
91156-image.png

  • 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!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,327 questions
No comments
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 24,091 Reputation points Microsoft Employee
    2021-04-26T18:59:05.673+00:00

    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.


0 additional answers

Sort by: Most helpful