Re: Q:Timed execution of PL/SQL?
From: Dr. Jan Dieckmann <jdieckmann_at_psi.de>
Date: 1998/03/16
Message-ID: <350D6B00.5C94_at_psi.de>#1/1
Date: 1998/03/16
Message-ID: <350D6B00.5C94_at_psi.de>#1/1
> Hi,
>
> I need to have a PL/SQL procedure run at midnight every night on my
> Oracle 7.3.2 database, how do I do that? Is there something similar to a
> unix crontab file?
Here is an examble to submit a job tmptest:
DECLARE
job BINARY_INTEGER;
BEGIN
dbms_job.submit( job, 'tmptest', sysdate, 'sysdate+1', FALSE);
END;
Our Tool Hora 3 offers a GUI to administer jobs. You can download a free
trial version of Hora 3 at www.keeptool.com.
Regards Jan Dieckmann
jan.dieckmann_at_keeptool.com
Received on Mon Mar 16 1998 - 00:00:00 CET