locked
Azure data factory copy activity schedule daily at 6:00 AM PST RRS feed

  • Question

  • Hi Guys,

    How do I schedule my Pipeline and output dataset run every day @ 6:00 AM PST; I tried below approach
         },
                    "scheduler": {
                        "frequency": "Day",
                        "interval": 1
                    },
                    "name": "CopyActivity-0"
                }
            ],
            "start": "2016-10-14T14:00:00Z",
            "end": "2099-12-31T08:00:00Z",

    But it executes only once at 12:00 AM but I want it execute at 0600 PST daily.
    Regards,
    Navin

    Navin.D http://dnavin.wordpress.com

    Saturday, October 15, 2016 8:48 PM

Answers

All replies

  • Hi Navin.D,

    This forum is about the SQL Server T-SQL programming, since your issue is more related to the Azure data factory, we would help you move it to the right forum for better support. If you have any issues about T-SQL, you’re welcome to post them here.

    Thank you for your understanding and support.

    Best Regards,

    Albert Zhang

    Monday, October 17, 2016 7:11 AM
  • Solution:

    availability": {

                "frequency": "Day",

                "interval": 1,

                "offset": "14:00:00"

            },

    Every time you change offset; you need to delete output dataset/pipeline related to it and create new schedule; which does not make sense should allow update as we change and deploy


    Navin.D http://dnavin.wordpress.com


    https://azure.microsoft.com/en-us/documentation/articles/data-factory-create-datasets/#offsetstyle-example
    • Marked as answer by Navind Monday, October 17, 2016 8:50 PM
    • Edited by Navind Monday, October 17, 2016 8:51 PM
    Monday, October 17, 2016 8:49 PM