Hi,
We have been using Orchestration to schedule our TDI execution packages and Ingest tasks, and have tasks running every other hour. We now have a new requirement to be able to pause our schedule for service windows of a couple of hours every 2nd month.
Does anyone know how to pause the schedule using Orchestration or some other tool?
Any help is greatly appriciated.
Best,
Leo
+5Hi
Schedules can be manually disabled and then re-enable them after the maintenance/service window. The schedules can be disabled either in the individual schedules or in the schedule groups
Alternatively, a holiday list can be setup, and then the schedules can be set to “ignore holidays property”
However this would pause the schedule for the entire day for the days set in the holiday list
In order to define a custom schedule excluding certain hours on specific dates, please use the “custom sql” option to define frequency. For more information please see the custom trigger section in the following article:
Thanks for your response
My use case requires pausing the schedule only for one hour on specific dates, so it looks like the Custom SQL approach is my best option. However, I ran into some issues while setting it up.
I’m unsure about how the database connection needs to be configured. Does the database being queried need to be set up as a Data Provider in Orchestration? Or is it possible to query my TDI tables using my existing TDI Data Provider?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
