Re: DBMS_JOB schedule

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 09 Feb 2005 20:26:45 +0100
Message-ID: <vuok01lj4gmjlb53kndtoe41oo9g1golig@4ax.com>

On 9 Feb 2005 02:31:07 -0800, "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote:

>
>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

Okay, thanks for the tip.

Jaap. Received on Wed Feb 09 2005 - 13:26:45 CST