Re: Job queue Question

With the interval of 'sysdate + 18/24' what you are saying is sysdate + 18 hours. So what you want the interval to say is 'sysdate + 1' and have the next_date = 6:00 pm.

I don't think that the interval of sysdate +1 will be really good, because I think it might start to slide, that is set itself to the sysdate of whenever the job completes plus 24 hours which means that if your job takes 1/2 an hour then then next_date will be 6:30 tommorrow and then after that 7;00 the next day etc...

A sloppy way to fix this would be to set one up for every day of the week:
interval would be something like 'next_day(trunc(sysdate),''MONDAY'') + 18/24'
and then another for tuesday etc...

I am sure that the other guys could suggest some better/less sloppy ideas though.

I hope this helps
--glen

amerar_at_ci.chi.il.us wrote:
>
> Hello,
>
> I put a job into the job queue with this command:
>
> VARIABLE jobno number;
> begin
> DBMS_JOB.SUBMIT(:jobno,
> 'cash_man.water_pull;',
> sysdate,
> 'sysdate + 18/24');
> commit;
> end;
> /
>
> I want the job to run everyday at 6:00pm.......this is not happening.
> Can someone help me out with the interval??
>
> Please cc a copy to email....
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_NOSPAMnau.edu

Received on Wed Jul 07 1999 - 15:46:08 CDT