Database Administration (MOSC)

MOSC Banner

Scheduled job runs 1hr late

edited Mar 22, 2013 4:44AM in Database Administration (MOSC) 2 commentsAnswered
 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 #

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center