Re: Howto Schedule a procedure

From: Ulrik Hoffmann <ulrik.peer_at_hoffmann-kiel.de>
Date: Thu, 19 Apr 2001 11:59:51 +0200
Message-ID: <9bmctk$977i4$1@ID-13717.news.dfncis.de>

"Amos" <amos_987_at_hotmail.com> schrieb im Newsbeitrag news:9bmahl$3ht$1_at_news.inter.net.il...
> I wrote a procedure which I want to automatically execute 3 times a day.
> There must be a package that will let me create a scheduled job.

You can use the dbms_job package.
Make sure, you have job_queue_processes set to more than 0 in your initora-file.

Then you can use the following example:

declare
a integer;
begin
dbms_job.submit(a,'ProcedureName;',sysdate,'sysdate+1/3'); commit;
end;

Bye
Ulrik Received on Thu Apr 19 2001 - 04:59:51 CDT