DBMS_JOB

[jmodic]

Let's say you wan't the procedure TEST() to be run every day at 8:00AM by DBMS_JOB. You would submit such a job with something like:

declare
  x binary_integer;
begin
  dbms_job.submit
   (job => x,
    what => 'test(trunc(sysdate)-1)',
    next_date => trunc(sysdate) + 8/24,
    interval => 'trunc(sysdate) + 8/24 + 1'
   );
  commit;
end;