Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB schedule

Re: DBMS_JOB schedule

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 9 Feb 2005 02:02:54 -0800
Message-ID: <1107943374.759646.244470@z14g2000cwz.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US