Skip to content
Home » Oracle » How to Set Scheduler Time Zone

How to Set Scheduler Time Zone

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;


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. Required fields are marked *