Re: Scheduler question
From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Sat, 14 Dec 2019 20:20:21 +0200
Message-ID: <CAKnHwteA1ScPE0391stkKMTCSvZLXnJgVE-fVKvhR6c0=A2M2w_at_mail.gmail.com>
Date: Sat, 14 Dec 2019 20:20:21 +0200
Message-ID: <CAKnHwteA1ScPE0391stkKMTCSvZLXnJgVE-fVKvhR6c0=A2M2w_at_mail.gmail.com>
Byday=Sun;bymonthday=1-21
On Sat, 14 Dec 2019 at 19:58, Mladen Gogala <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
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Dec 14 2019 - 19:20:21 CET