3 Replies Latest reply: Dec 4, 2012 12:35 PM by EdStevens RSS

    Scheduler and Report Time Conflict

    792290
      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
          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
            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
              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'.