Can a Scheduled Database Task be set up to run multiple times a day, on specific weekdays, without creating a separate scheduled task for each time slot (e.g. 3 runs a day, Monday to Friday)?

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

Yes — a single Oracle DBMS_SCHEDULER-style calendar expression can express multiple times and specific weekdays in one schedule, avoiding the need for separate task entries per time slot. For example, FREQ=DAILY; BYTIME=063000,120000,171500; BYDAY=MON,TUE,WED,THU,FRI runs the task at 06:30, 12:00, and 17:15 every weekday. This scales much better than creating one job per site/time-slot combination when you have several sites each needing the same multi-times-a-day pattern.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions