Scheduled job runs 1hr late
Hi All,
I have scheduled some of the stats job for some tables and observed that it runs after 1hr from scheduled time.
Not sure whether this is due to daylight savings
i see the job dba_scheduler_jobs shows 3:45AM (for example) as NEXT_RUN, however, it runs only at 4:45AM? i see server timestamp & database timestamp looks ok shows same time
SQL> host date
Thu Mar 21 21:45:53 EDT 2013
SQL> select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') from dual;
TO_CHAR(SYSDATE,'DD-MON-YY
--------------------------
21-MAR-2013:21:45:58
Here is the database properties for review. This is 10g(10.2.0.4) release.
DICT.BASE 2 dictionary base tables version #
0