Problem when use Task Scheduler run excel

Question

Hi, everyone
I have a problem when using a task scheduler to run excel.
I set up the task scheduler at 2:30 AM JST (Japan Time). The task scheduler calls an excel. In that excel using the TODAY() method, but I got a 5:30 PM (UTC time) of the day before.
So how to set to get JST?

Answer 1

Hi DucVo-7122,

Try these steps and see if they are helpful to you

Login as administrator.

Change the instance timezone to Japan.

Go to the sys_trigger table.

Select any scheduled job where trigger type is "Daily". Notice the record will show the hour difference in the Next Action and Run Time.

Go back to the homepage and change the timezone to Japan(JST).

Go back to the sys_trigger table.

Select again any scheduled job where trigger type is "Daily". Notice the record will show no difference in the time with the Next Action and Run Time.

---

--If the reply is helpful, please Upvote and Accept it as an answer--