Re: Scheduling Processes

azmoodeh_at_netcom.com (Someone) wrote:

>I have a script that inserts rows into a table and then deletes those
>rows from the first table. I need to do this on a daily basis. Is there
>a way for me to write a procedure and then schedule that procedure to be
>executed everyday automatically? Also, is there a way for me to stop
>execution if an error occurs in the first part of my script?
>Thanks in advance for your replies.

Mickey,

If you are running Oracle 7.1 there's a package called DBMS_JOB which allows you to schedule stored procedures to run at specified intervals etc. I think the package may also be available on 7.0.16 but am not sure.

Hope this helps. Received on Wed Aug 23 1995 - 00:00:00 CEST