Re: Scheduling operations in Oracle

odysscci_at_teleport.com (Jim Kennedy) wrote:

>>In article <4fpgpl$abv_at_ratatosk.uio.no> torfridl_at_ulrik.uio.no (Torfrid Leek) writes:
 

>>In 7.2 there is the DBMS_JOB package, which does just this.
>>You can queue upto 10 "jobs" (pieces of PL/SQL) for later execution.
>>You can specify that they should run at regular intervals.
>>This is documented in chp. 7 of the Server Administrator's Guide.
>>Regards, Torfrid
 

>>torfrid.leek_at_usit.uio.no
>Actually, you can queu up more than 10 jobs, you can only have 10 jobs
>processes running jobs at the same time.

>Jim Kennedy

Is there a performance hit on the server for running DBMS_JOB, and does DBMS_JOB run on all 7.2+ servers?

Regards,
Paul Osborn
posborn_at_menlosoftware.com Received on Wed Feb 21 1996 - 00:00:00 CET