Re: DBMS_JOB schedule

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 09 Feb 2005 11:10:34 +0100
Message-ID: <g7oj011d1n5hqg6ljo9f6cssfg1jj0bo1c@4ax.com>

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. Received on Wed Feb 09 2005 - 04:10:34 CST