Support for Daylight Savings Time for Trigger Schedules
Setting up the timing of a Trigger, you need to know how far away from UTC you are so you can specify the right time. That value changes for those of us that observe Daylight Savings Time.
The dialog box for setting up a Trigger Schedule should instead have the following three inputs:
1) the LOCAL time you want it to run
2) the Time Zone
3)Adjust for DST.
THAT is the information people have at their disposal.
To adjust for DST, I must EDIT all my Triggers manually to ensure they run at the right hour of the day when we change over to/from DST.
richard hudson commented
This is very poor. Most legacy systems handle this (SQL Agent) for example. Producing modern technology that introduces bugs that have been fixed 40 years ago should not be something to be proud of or make excuses about...
Tim Kracht commented
Can you please let us know when this feature will be supported officially, as we are approaching production release.
Fang Liu commented