im a bit confused in regards to the occasion scheduler. First off, it’s working and dealing, however the timezone dealing with confuses me a bit, because it appears it is not what’s documented on occasions metadata
So to begin off, they are saying, mysql.occasion desk holds occasion information as properly. This desk doesn’t exist on our system.
It additionally says in data schema, begins and last_executed are displayed as occasion timezone, however that doesnt appear to be the case on our system as properly.
begins = reported as ‘system’ time zone, currntly utc -0400, therefore i needed to make the beginning time -Four hours to have it run in utc at begin of subsequent month (2019-07-31 20:00:00).
I do know i can set the session timezone to utc.
Whereas that works, as quickly as you edit the occasion, the outdated will get deleted and a brand new create occasion is triggered by phpmyadmin ( probably bug? ).
I additionally know i can run the instructions in sql tab with alter occasion, however i’m not the oly one accessing the system, and anybody may basicly use the occasion interface to edit the occasion = again to system timezone
timezone reported after including is system (utc -4)
on an take a look at run, final executed was in utc ( no downside actually, however its not what docs say )
Now docs say mysql.occasion shows the beginning used so as to add the occasion in utc ( once more our system not has this desk ) and shops the timezone used to stop flawed timings when altering timezones
What occurs after we probably change the system timezone at a later level? since data schema stories as system and never -0400 what would occur to our occasion which proper now has a begins time of 31.07.2019 20:00:00?
Say we modify to utc, would the begins column replace to mirror this transformation? Would the timezone mirror the change?
I am afraid our occasion would then probably run at 8pm in utc as an alternative of -0400, since timezone in data schema would possibly nonetheless be ‘system’ then.
Anybody has some perception on this?
Do not actually need to mess with the worldwide timezone to check this out, since system is in manufacturing.
Admire any assist/insights on this,