USE CASE I: [BASIC TYPE] Schedule the integration for every 10 minutes. For this type there is minimum frequency limit of 10 minutes. If you try to define a schedule frequency of under 10 minutes, a validation error occurs. Use iCal to schedule the integration below 10 minutes.
USE CASE II: [ADVANCE TYPE] Schedule the frequency for every 5 minutes using iCal expression.
Lets see the steps in detail :
CASE I :
Step 1 : Activate the scheduled integration and then click on the hamburger
sign. Select Add Schedule.
Knowledge : 👀
App Driven Orchestration ? : It enables you to create an integration that uses an event or business object to trigger the integration. In laymen's terms - you have to pass some inputs to trigger the app driven orchestration integrations.
Scheduled Orchestration ? : It enables you to create an integartion that uses a schedule to
trigger the integration instead of an adapter. After designing such integration, you can schedule when to run it.
Step 2 : click Add Schedule
Step 3 : Now set the frequency by clicking on Only once
Step 4 : Select Hours and Minutes because our requirement is to submit the
Integration in every 10 minutes.
Note : you can select other option(Days,Weeks etc.) as per your requirement.
Step 5 : Enter 10 in minutes box.
Step 6 : Click Save and then click Close.
Step 7 : Click Start Schedule.
Click Start.
Done.Your integration is scheduled for every 10 minutes. Now close the scheduling window. Integration will automatically get submitted inevery 10 minutes interval of time.
CASE II :
Step 1 : After step 2 in case I, select TYPE : ADVANCED
Step 2 : Enter below iCal Expression to schedule the integration for 5 every
5 minutes interval of time.
FREQ=MINUTELY;INTERVAL=5;
Click Validate Expression.
Knowledge : 👀
FREQ=MONTHLY;BYMONTHDAY=1,10,15;BYHOUR=5,10,15,20;BYMINUTE=15;
The following expression indicates that this integration runs each month on the 1st, 10th, and 15th days of the month at 5:15 AM,10:15 AM, 3:15 PM , and 8:15 PM.
Step 3 : Click Start Schedule
Click Start.
Done.Your integration is scheduled for every 5 minutes. Now close the scheduling window. Integration will automatically get submitted inevery 5 minutes interval of time.
Thanks for sharing
ReplyDeleteWelcome Shelja :)
DeleteThanks for the details, do you have any sample to exclude a particular day from the daily schedule? Thanks in advance.
ReplyDeleteVino, I have to check , will update you.
DeleteHi Vino, Oracle team has confirmed that as of now here is no iCal expression which will prevent integration from running on specific dates.
DeleteFREQ=MONTHLY;BYMONTHDAY=10,25;INTERVAL=1;
DeleteAll you have to do is change the values and specify the dates you want to run the schedule.
Hi Unknown , we need expression to exclude a specific day from daily scheduler (example 15th August, 26 Jan etc). What you are suggesting is already discussed and it's not practical. Requesting you to please cross check and share practical solution :)
DeleteCan we schedule a job in OIC such that the job runs every hour only from 9:00 AM to 6:00 PM. It doesn't run for the entire day.
ReplyDeleteDear you can try below one & please let me is it working or not :)
DeleteFREQ=DAILY;BYHOUR=9,10,11,12,13,14,15,16,17,18;
it is working. You can use it
Deletei have cloned an integration which has a schedule how to remove that schedule
ReplyDeletePlease check below article :
Deletehttps://www.oicbasics.com/2021/07/delete-schedule-in-oic-scheduled.html
I need to schedule an integration for first working day of every month. How to do this?
ReplyDeletethere is a limitation of iCal expression, i think you can't achieve your requirement using iCal expression. Please connect oracle support
Delete