Re: "OK" to loop on DBMS_SLEEP ???

> I 'm using DBMS_JOB to schedule a function to simply check if an OS file
> exists, the file may not be there just yet...
> so Im thinking of putting in a loop around DBMS_SLEEP to keep sniffing for
> few minutes....

Will DBMS_JOB start the job once and then you'll look for the file, sleep some seconds, look for the file and so on? The purpose of DBMS_JOB is to start jobs at specified intervals, if you tell it to start the lookup every 5 minutes it will do so. You don't need DBMS_SLEEP, it is tautological. Does this job really has to run from the database side? Why don't you use cron or at (depending on your OS)?

Regards,

Knut Received on Mon Apr 15 2002 - 12:28:49 CDT