Hi,
Sage X3: v12p33
For reference:
My local timezone is UTC+8. Sage X3 also using this timezone. I have no idea how to set this from Sage X3 side.
The AWS RDS SQL Server database is at UTC+0.
Batch Server query timing seems to work based on SQL Server database timezone (which is UTC+0 in this case).
I cannot change the SQL Server database timezone as this database is required to be stored in UTC+0 timezone.
While working on a folder migration, I have observed that `Usage > Sequencing Monitor` automatically provides the migration task code with local time rather than database time like when using `Usage > Query` submission.
How do I adjust Sequencing Monitor to set timing match database time automatically?
My current workaround is to manually adjust -8 hours but it is extremely tedious to do since I need to fix timing around 90 entries.
Task code: AMOULIN4
New requests in green, completed request in black. Observe the timing difference: