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

> Why don't you use cron ....

   <smile>...thanks...I knew this'd come up.... Well, since what Im looking to do is not so complex in term of interacting with the OS and is totally do-able from Oracle, I want to do from w/i the db. Because the next step is to read and load that file into a table. so the whole thing is dependent on the db being up.

rc

Knut Talman wrote in message <3CBB0DD1.76AFED7D_at_mytoys.de>...
>> 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 - 13:33:16 CDT