Re: Scheduler question

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 14 Dec 2019 13:21:36 -0500
Message-ID: <39eb3848-c2d3-e69e-b615-e0ce2823772f_at_gmail.com>



Thanks Ilmar!

On 12/14/19 1:20 PM, Ilmar Kerm wrote:
> Byday=Sun;bymonthday=1-21
>
> On Sat, 14 Dec 2019 at 19:58, Mladen Gogala <gogala.mladen_at_gmail.com
> <mailto:gogala.mladen_at_gmail.com>> wrote:
>
> I have to schedule a job that will run first 3 sundays in the
> month and
> am not at all sure how to do it. For now, my only solution is to
> have a
> table with all Sundays untilĀ  01/01/2100 and exit if the Sunday is
> the
> 4th Sunday in the month. Is there a smarter way of doing that through
> the DBMS_SCHEDULER?
>
> Regards
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> Ilmar Kerm

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l
Received on Sat Dec 14 2019 - 19:21:36 CET

Original text of this message