Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to SPAWN PL/SQL proc each 2 hours ?
Dadak Jakub (indad_at_fce.vutbr.cz) wrote:
: i want to spawn a PL/SQL stored procedure each 2 hours. In MSSQL
: stored procedure exist which register another function to spawn
: at decribed time.
Does dbms_job help ?
Other than that you could look at using an operating system level scheduler such as 'cron' on Unix.
IAP
-- In an attempt to reduce junk email I use an invalid 'From' address. My correct email address can can be determined by replacing 'not.valid' with 'value.net'Received on Tue May 20 1997 - 00:00:00 CDT
![]() |
![]() |