Skip to content

How to Set Scheduler Time Zone

  • by

Scheduler Time Zone

Before doing that, we have make sure the time zone region you want to set is valid for Oracle.

Then we change the default time zone (DEFAULT_TIMEZONE) of scheduler in database as following.

SQL> exec dbms_scheduler.set_scheduler_attribute('default_timezone', 'Asia/Hong_Kong');

PL/SQL procedure successfully completed.

You can see more usages about DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE procedure in documentation.

Then check scheduler default time zone again.

SQL> select dbms_scheduler.stime from dual;

STIME
---------------------------------------------------------------------------
09-MAR-22 09.53.38.123446000 AM ASIA/HONG_KONG

We're good.

Please note that, STIME is a function of DBMS_SCHEDULER, which can display current scheduler time stamp with time zone.

Leave a Reply

Your email address will not be published.