This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Jul 9, 2010 7:18 AM by 573274 RSS

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

573274 Newbie
Currently Being Moderated
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

Legend

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