Re: schedule job on Oracls 7.3 for NT

On Thu, 01 Oct 1998 13:04:42 +0800, "§õÄ£©v" <richard_at_synnex.com.tw> wrote:

>I need to run a store procedure every 10 mins from 08:00 to 20:00 every
>day,is there someone can help me?
>
>Regards
>Richard Lee
>

Take a look at the dbms_job-package. There are several functions for scheduling procedures, using the oracle job-queue. The time-window from 8:00 to 20:00 you have to handle for yourself (if to_char(sysdate,'hh24miss') between '0800' and '2000' then ...)

Hope that helps...

Jens
Jens Mayer
Rat&Tat GmbH
Hamburg
jmayer_at_ratundtat.com Received on Fri Oct 02 1998 - 09:44:13 CDT