This discussion is archived
3 Replies Latest reply: Dec 4, 2012 10:35 AM by EdStevens RSS

Scheduler and Report Time Conflict

792290 Newbie
Currently Being Moderated
Hello,
We have scheduled some Jobs such as monthly, semi-annually reports using dbms_scheduler. we use 10gR2 software and windows 2003 server. we have a report which supposed to run at 4:00 AM and as soon as the report finishes it sends the report as email to the authorized users. when the scheduler ran the report inside the report it shows as ran at 3:08 AM where they get systimestamp. but when i query the

select last_stat_time, next_run__date from dba_scheduler_jobs where job_name ='TEST';

last_start_time next_run_date
03-DEC-12 04.00.00..223000 AM -04:00 07-JAN-13 04.00.00..200000 AM -04:00

when I query systimestamp from dual on that database from sqlplus:
i get the following:
systimestamp
04-DEC-12 07.40.16..152000 AM -05:00

I see the difference of -04.00 and -05.00 from both of the queries. i know the systimestamp from dual is correct. how to I fix the scheduler Job to run at the correct time with daylight savings to take effect?

Help is much appreciated.

Thank you.
  • 1. Re: Scheduler and Report Time Conflict
    EdStevens Guru
    Currently Being Moderated
    789287 wrote:
    Hello,
    We have scheduled some Jobs such as monthly, semi-annually reports using dbms_scheduler. we use 10gR2 software and windows 2003 server. we have a report which supposed to run at 4:00 AM and as soon as the report finishes it sends the report as email to the authorized users. when the scheduler ran the report inside the report it shows as ran at 3:08 AM where they get systimestamp. but when i query the

    select last_stat_time, next_run__date from dba_scheduler_jobs where job_name ='TEST';

    last_start_time next_run_date
    03-DEC-12 04.00.00..223000 AM -04:00 07-JAN-13 04.00.00..200000 AM -04:00

    when I query systimestamp from dual on that database from sqlplus:
    i get the following:
    systimestamp
    04-DEC-12 07.40.16..152000 AM -05:00

    I see the difference of -04.00 and -05.00 from both of the queries. i know the systimestamp from dual is correct. how to I fix the scheduler Job to run at the correct time with daylight savings to take effect?

    Help is much appreciated.

    Thank you.
    More appropriate for the Scheduler forum (Scheduler but I can tell you that if the job schedule is specified with a time zone expressed as a GMT offset (as yours are) then it is NOT "dst aware". Also comes into play if you are using a pl/sql function vs. the scheduler calendaring expressions for REPEAT_INTERVAL.

    I'd suggest you close this msg and start again in the proper forum. You'll get better and more focused help there.
  • 2. Re: Scheduler and Report Time Conflict
    792290 Newbie
    Currently Being Moderated
    i closing this topic here and opened in scheduler as per Ed steven suggestion. i did not find any where it says close this topic.
  • 3. Re: Scheduler and Report Time Conflict
    EdStevens Guru
    Currently Being Moderated
    789287 wrote:
    i closing this topic here and opened in scheduler as per Ed steven suggestion. i did not find any where it says close this topic.
    just mark it 'answered'.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points