Re: Scheduler question

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