Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Scheduling a PL/SQL Program?
I have a PL/SQL block that I need to execute after midnight every night to update the content of a table. Should I embed this as a subprogram directly into the database (I currently run it from SQL*Plus, but have problems getting it to run as a cron job)? If I do that, how do I trigger it at a given time each day?
Thanks,
Mark Tortolano Received on Tue May 12 1998 - 05:13:03 CDT