Re: Scheduling a PL/SQL Program?

Look at the DBMS_JOB package. Refer to a PL/SQL book for the description. This is a good solution because it is integrated into the database. Remember to create at least one job queue. There are two parameters, # of queues and rep rate, to update in initSID.ora. One queue running every 60 seconds is fine.

Also remember to commit after submitting the job.

sql statements:
execute dbms_jobs.submit(,,,); (I think it is submit, but check it out). commit;

You can veiw the queue entries via:

select * from dba_jobs

Scott Received on Sat May 16 1998 - 00:13:47 CDT