Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB schedule
suresh manampilly via OracleMonster.com wrote:
> Folks,
>
> I have a job running everyday after noon 1pm but I want to reschedule
this job to run everyday 1pm but only on saturdays run at 3pm.How do I
set the interval?
>
> TIA
>
> Suresh
decode(to_char(sysdate, 'DAY'),
'FRIDAY', trunc(sysdate + 1) + 15/24, trunc(sysdate + 1) + 13/24)
Regards
/Rauf
Received on Wed Feb 09 2005 - 04:02:54 CST