Re: DBMS_JOB

Hi Steve,

I have overcome this problem by wrapping the stored procedure in another stored procedure

create procedure hour_job
AS

BEGIN IF to_char(sysdate,'hh24:mi') in ('09:00','12:00','14:00','17:00') THEN procedure1;
procedure2;
END IF;
END;
/

You could then submit hour_job so that it ran every hour, except that 9,12,14,17 hours it would actually do something. There are other ways to do this but this seemed the most straight forward, and didn't require any new tables
to use in in the interval calculation.

Nevin Hahn
nhahn_at_evoke.com

Steve_at_e-DBA <steve.taylor_at_e-dba.net> wrote in message news:8p5mv7$jbj$1_at_nntp.mistral.co.uk...
> I am trying to schedule a job to run four times a day, i.e. 09:00, 12:00,
> 14:00 and 17:00.
>
> can I get 1 job to do this, and if so what is the syntax? or do I have to
> create four diff. jobs.
>
> I want them to run at these time intervals every day.
>
> Thanx
>
>
>
>
Received on Wed Sep 06 2000 - 15:34:52 CDT