Does anyone have any ideas on how to schedule a report at 8:20am when it’s GMT but to dynamically have the schedule change to 9:20am when the UK switches to BST?
We currently have to remember to change the schedule twice a year to counter this.
The universe is pointing at ProgresSQL database so not sure if a universe object could be used to create a BST/GMT Flag, then use a 2 publications one that runs at 8:20 for GMT and one that runs at 9:20 when BST but this means having 2 schedules all year round
I thought of a file triggered event, but not sure how to set something up to create the trigger file (we are on windows servers)
Any suggestions welcome