Re: trigger help??? time stamp
From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 22 Jan 2001 13:37:24 GMT
Message-ID: <oIWa6.297168$U46.9483860_at_news1.sttls1.wa.home.com>
Date: Mon, 22 Jan 2001 13:37:24 GMT
Message-ID: <oIWa6.297168$U46.9483860_at_news1.sttls1.wa.home.com>
Look at the dbms_job package. Make sure in your init.ora file you have job_queue_processes>0 (e.g. 2) and job_queue_interval>0 (e.g. number of seconds between times you want it to check for a job to do 600 is good) Jim
"Serge Nantel" <snantel_at_sympatico.ca> wrote in message
news:3A6AEF9F.10C9EC13_at_sympatico.ca...
> Is it possible to create a trigger based on a time stamp ( like avery
> night at 01:30 do someting....)
>
Received on Mon Jan 22 2001 - 14:37:24 CET