Scheduler question

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 14 Dec 2019 12:56:48 -0500

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


Other related posts: