question

NareshE-6629 avatar image
0 Votes"
NareshE-6629 asked NareshE-6629 commented

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

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
image.png (92.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered NareshE-6629 commented

Hello @NareshE-6629 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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you @MartinJaffer-MSFT for confirming. Yes, it will be a great feature to physically see when my pipeline will run for future dates, as it is not feasible to test the exact thing and there will be a part left untested and will be haunting us. I shall upvote.

1 Vote 1 ·