"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....

Is it "ok" to use DBMS_SLEEP to do this ? that is, is this an acceptable practice or Am I doing something wrong & wasting resources ? Thanks
robert Received on Mon Apr 15 2002 - 11:42:35 CDT