How to schedule OIC integration and iCal Expression
– Advertisement –
CASE I :
– Advertisement –
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.
Click Start.
Done. Your integration is scheduled for every 10 minutes. Now close the scheduling window. Integration will automatically get submitted in every 10 minutes interval of time.
– Advertisement –
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.
– Advertisement –
Step 3 : Click Start Schedule
Click Start.
– Advertisement –
You may also like
38 comments
Leave a Reply to Anonymous Cancel reply
Archives
- November 2024
- October 2024
- May 2024
- June 2023
- December 2022
- October 2022
- September 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- August 2021
- July 2021
- May 2021
- March 2021
- January 2021
- November 2020
- October 2020
- September 2020
- May 2020
- March 2020
- February 2020
- January 2020
- December 2019
- August 2019
- July 2019
- June 2019
- May 2019
- March 2019
Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||














Thanks for sharing
Thanks for the details, do you have any sample to exclude a particular day from the daily schedule? Thanks in advance.
Vino, I have to check , will update you.
Hi Vino, Oracle team has confirmed that as of now here is no iCal expression which will prevent integration from running on specific dates.
FREQ=MONTHLY;BYMONTHDAY=10,25;INTERVAL=1;
All 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 🙂
Welcome Shelja 🙂
Can 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.
Dear you can try below one & please let me is it working or not 🙂
FREQ=DAILY;BYHOUR=9,10,11,12,13,14,15,16,17,18;
it is working. You can use it
i have cloned an integration which has a schedule how to remove that schedule
I need to schedule an integration for first working day of every month. How to do this?
Please check below article :
https://www.oicbasics.com/2021/07/delete-schedule-in-oic-scheduled.html
there is a limitation of iCal expression, i think you can't achieve your requirement using iCal expression. Please connect oracle support
Hi Kabir,
https://stackoverflow.com/questions/18101167/can-ical-schedule-an-event-for-the-first-weekday-after-bymonthday-if-bymonthday
i think this would help ….
Hi, Is there anyway to pass some date parameters as input to Scheduler in OIC ? For Example, send previous day's date as input when the scheduler runs.
Thanks
Srikar Sreeram
Yes Sreeram, you can pass Inputs as 'Schedule Parameters' in a Schedule Integration.
Please note currently I don't have any article related to it. Tomorrow I will share it with you 🙂
integration does not run an particular period of time by using ical expression like for example…integration doesnot run on month jan1,march4,and aug10
Hi
I have an requirement, integration does not run on specific days plz help
Thank you.
with iCal expression you can't exclude dates.
but I can suggest you one solution for your requirement : Just Store holiday list in a DB table or OIC lookup. If Interface Run date = Holiday date then stop the interface at the start.
Thanks for the post!
I am looking for how to develop custom adapters for OIC.
Do you get that info?
Please let me know how to submit OIC integration for multiple parameters and multiple Times.
Ex: Parameter: C01, Time : 2PM, 3.30PM, 7.45PM
Parameter: C02 ,Time : 8PM, 11.45PM.
Currently we are achieving with wrapper integrations which is not appropriate.
I don't know about it
Sure Kabir.
Can we schedule a job in OIC integration such that the job runs every day but not from 12:00 am to 8:00 am on Sunday?
If yes please tell how to write the ical expression
query answered through the email. Please check
how to schedule a App Driven Orchestration integration.
trigger it from a schedule integration
Can we schedule OIC integration such that the job runs every day on hourly basis but skip Sunday 9 am to 6 pm?
Hi Kabir, Is there any way or ical expression to schedule the integration on public holiday?
I think you can use iCal ….
If you have the list of public holiday days available, you can try below expression :
FREQ=MONTHLY;BYMONTHDAY=10,25;
All you have to do is change the values and specify the public holiday dates you want to run the schedule.
With the help of Appdervien orchestration, can we change the scheduled timings for the scheduled integration.
Hi Kabir sir
.what is the difference between soap mapper level hardcoded the 'sizeOfDataChunkDownload' '-1' and '0' what is the main difference between these two?
.how do get more than 10mb data from fusion?
is this question related to this article ? no right ? better Anonymous SIR asked the question related with the article, don't just dump question SIR 🙂
Hi kabir, can you please help on this requirement
Integration should run every 12 days of a month and every Sunday, Integration should not run on Saturday.
I don't think iCal can handle this. You can connect oracle support for iCal expression.
But we can do some workaround to achieve this, using some logic, please text me here 'thekabiryadav@outlook.com' . Will connect.