Version: 11.2.0.2.0
Hello Guys, got a bit of a problem on which I am stuck.
There are couple of jobs that are scheduled through DBMS_SCHEDULER to run on 11:20 AM today
select start_date from dba_scheduler_jobs;
START_DATE
3/12/2014 11:20:10.000000 AM -05:00
3/12/2014 11:20:10.000000 AM -05:00
3/12/2014 11:20:10.000000 AM -05:00
3/12/2014 11:20:10.000000 AM -05:00
But now when I do "select systimestamp from dual;" I get the following result
SYSTIMESTAMP
3/12/2014 12:21:33.313791 PM -04:00
I think it is because of the Day light saving that set the clock 1 hour forward last Saturday that this issue arose. Is there any way to fix this issue so that the jobs will run on 11:20AM instead of 12:20PM instead of having to reschedule those jobs again.
I read in one post to do the following, would this help?
BEGIN
DBMS_SCHEDULER.set_scheduler_attribute (
attribute => 'default_timezone',
value => 'US/Eastern');
END;
/
Thank You