1 2 Previous Next 21 Replies Latest reply: Jul 9, 2010 9:18 AM by 573274 RSS

    Schedule a job to run a procedure at a specific time everyday.

    573274
      Hi,
      I am working on Oracle 10g database. I am trying to run a procedure everyday as a schedule to be run at 6.45 PM. I used the anonymous block below as suggested in one of the replies to my earlier thread. It executes the script first time around 6:45 PM and the next day onwards it executes at midnight. This is resulting in some duplicate records being inserted. How do I make it run every day exactly at 6:45 PM? The code needs to go to production soon and appreciate an early response.

      Regards,
      Raj Naraparaju.

      BLOCK:_
      begin
      dbms_job.submit(job => my_job,
      what => 'Daily_TRAN(sysdate-140,sysdate-139);',
      next_date => trunc(sysdate)+1+(18*60+45)/(24*60),
      interval => 'trunc(sysdate)+1');
      commit;
      end ;
      /
        1 2 Previous Next