Skip to content
October 31, 2011 / doganay

SCHEDULER JOB DAYLIGHT SAVING PROBLEM

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Hi,

You can crate a schedule like this. Bu DO NOT USE timezone region (i.e. Europe/istanbul).

I have a schedule that runs once every 2 hours. I had created it using timezone region europe/istanbul.

In turkey, time moved from 30.10.2011 04:00 to  30.10.2011 03:00.

So my job ran like this:

30.10.2011 01:15

30.10.2011 03:15

30.10.2011 04:15

30.10.2011 06:15

it is a problem, because I wanted it to run on odd hours, not even.

So, I altered schedule and fix it after time moved back.

 
To eliminate this problem, you have to create schedule like this: (DO NOT USE TZ Region)

BEGIN
  SYS.DBMS_SCHEDULER.DROP_SCHEDULE
    (schedule_name  => 'MYUSER.TEK_SAATLERDE_ONBES_GECE');
END;
/

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_SCHEDULE
    (
      schedule_name    => 'MYUSER.TEK_SAATLERDE_ONBES_GECE'
     ,start_date       => TO_TIMESTAMP_TZ('2011/10/31 13:15:00.000000','yyyy/mm/dd hh24:mi:ss.ff')
     ,repeat_interval  => 'FREQ=HOURLY; INTERVAL=2; BYMINUTE=15; BYSECOND=0'
     ,end_date         => NULL
     ,comments         => NULL
    );
END;
/

try and pray 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: