Data Factory Scheduled Trigger not triggerring

Question

I have a simple trigger

Should run at UTC+1 but the trigger is never running.

Things I tried:

1. Running it every 1 minute --> Does not work

1. Clicking on "Trigger Now" --> it works, but it is not scheduled trigger
2. 

Why is it not working ?

Thanks in advance

Answer 1

Hi @Vedant Desai

The pipeline is expected to fail, since I want to check if the alerts are working. But it still should be triggered even if it fails.

Please find the JSON of the trigger below:

{
    "name": "tr_test",
    "properties": {
        "annotations": [],
        "runtimeState": "Started",
        "pipelines": [
            {
                "pipelineReference": {
                    "referenceName": "test",
                    "type": "PipelineReference"
                }
            }
        ],
        "type": "ScheduleTrigger",
        "typeProperties": {
            "recurrence": {
                "frequency": "Day",
                "interval": 1,
                "startTime": "2023-05-15T07:18:00",
                "timeZone": "W. Europe Standard Time",
                "schedule": {
                    "minutes": [
                        0
                    ],
                    "hours": [
                        6
                    ]
                }
            }
        }
    }
}

Please find the JSON of the pipeline below

{
    "name": "test",
    "properties": {
        "activities": [
            {
                "name": "create_watermark_table",
                "type": "Script",
                "dependsOn": [],
                "policy": {
                    "timeout": "0.12:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "userProperties": [],
                "linkedServiceName": {
                    "referenceName": "ls_snf_rawDb_basicAuth",
                    "type": "LinkedServiceReference"
                },
                "typeProperties": {
                    "scripts": [
                        {
                            "type": "Query",
                            "text": "dsource_tablename VARCHAR(100)\n    , target_nameddddddddddddddddddd"
                        }
                    ],
                    "scriptBlockExecutionTimeout": "02:00:00"
                }
            }
        ],
        "variables": {
            "table_name": {
                "type": "String"
            }
        },
        "annotations": [],
        "lastPublishTime": "2023-03-02T12:37:48Z"
    },
    "type": "Microsoft.DataFactory/factories/pipelines"
}

Answer 2

Hey there

I've reviewed the JSON for your trigger and pipeline, and I think I can help you troubleshoot the issue.

First, I noticed that your trigger is configured to run at UTC+1. However, the time zone for your Data Factory is set to UTC. This is likely why your trigger is not running at the expected time.

To fix this, you need to change the time zone for your Data Factory to UTC+1. You can do this by following these steps:

1. Go to the Azure portal and open your Data Factory.
2. Click on the "Settings" tab.
3. In the "Time zone" field, select "UTC+1".
4. Click on the "Save" button.

Once you have changed the time zone for your Data Factory, your trigger should start running at the expected time.

If you are still having trouble with your trigger, please let me know and I will be happy to help further.

Please don't forget to click on

and upvote

button if you find this helpful.