I agree with most everything except:
> If I want a report of what happened at a specific time I need that report at local time
this is hard when a particular hour can happen twice in a day right?
I agree with most everything except:
> If I want a report of what happened at a specific time I need that report at local time
this is hard when a particular hour can happen twice in a day right?
It certainly is, but that's a business question, not a technical question
If the business requires it to run at 01:30 and there are two per day, or zero per day, then the business rules needs to define what happens. You can't solve this by running it at UTC.
Technically correct, but the business needs to be aware and a solution needs to be proposed beforehand IME. UTC is such a solution, imperfect, but usually workable. Business rules are sometimes unexpectedly elastic when confronted with a particularly explosive mix of logic and legislation.