Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Trigger question
Use the dbms_job facility to submit a pl/sql stored procedure as batch job in Oracle.
Hth,
Sybrand Bakker, Oracle DBA
Rookie <Rookie.Programmer_at_gte.net> schreef in berichtnieuws
OQnU4.1999$ec.271771_at_dfiatx1-snr1.gtei.net...
> I would like to update a status field from open to close when the
> corresponding date field reaches today's date.
>
> Should I just run a batch routine every night, or can I schedule Oracle 8i
> to handle this for me automatically every night?
>
>
Received on Wed May 17 2000 - 00:00:00 CDT