Re: DBMS_JOB schedule

Jaap W. van Dijk wrote:
> On 9 Feb 2005 02:02:54 -0800, "Rauf Sarwar" <rs_arwar_at_hotmail.com>
> wrote:
>
> >
> >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
>
> Is the contents of INTERVAL used in PL/SQL scope (where decode is not
> allowed) or SQL scope?
>
> Jaap.

It's SQl scope. Oracle calls "select interval into next_date from dual;" just prior to executing the job to set the next_date. You can even use a PLSQL function to resolve complex interval.

Regards
/Rauf Received on Wed Feb 09 2005 - 04:31:07 CST