Scheduler question
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 14 Dec 2019 12:56:48 -0500
Message-ID: <dc1497d2-1911-d2c3-3225-a77da8a1788e_at_gmail.com>
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?
Date: Sat, 14 Dec 2019 12:56:48 -0500
Message-ID: <dc1497d2-1911-d2c3-3225-a77da8a1788e_at_gmail.com>
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
Received on Sat Dec 14 2019 - 18:56:48 CET