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@xxxxxxxxx <mailto:gogala.mladen@xxxxxxxxx>> 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
--
//www.freelists.org/webpage/oracle-l
--
Ilmar Kerm