Introduction/ Issue:
How to defining Complex Scheduling for Scheduled Integration in OIC?
Why we need to do / Cause of the issue:
ICal Expressions in OIC is used for defining Complex Scheduling for Scheduled Integration
With default scheduling options we will be only able to Schedule the integration with below options.
- Hours and Minutes
- Days
- Weeks
- Months
If there is any requirement to schedule the integration apart the above standard options then we might need to use iCal expression to archive it below is one such example.
Requirement: Schedule an integration from Sunday to Thursday 8 AM to 8PM for every 30 minutes for 1 years
How do we solve:
Ical expression : FREQ=WEEKLY ;INTERVAL=54;BYDAY=SU,MO,TU,WE,TH;BYHOUR=8,9,10,11,12,13,14,15,16,17,18,19,20;BYMINUTE=0,30;
Below are Syntax uses to build iCal expression.
freq = “SECONDLY” / “MINUTELY” / “HOURLY” / “DAILY”/ “WEEKLY” / “MONTHLY” / “YEARLY”
( “;” “INTERVAL” “=” 1*DIGIT ) /
( “;” “BYSECOND” “=” byseclist ) /
( “;” “BYMINUTE” “=” byminlist ) /
( “;” “BYHOUR” “=” byhrlist ) /
( “;” “BYDAY” “=” bywdaylist ) /
( “;” “BYMONTHDAY” “=” bymodaylist ) /
( “;” “BYYEARDAY” “=” byyrdaylist ) /
( “;” “BYWEEKNO” “=” bywknolist ) /
( “;” “BYMONTH” “=” bymolist ) /
( “;” “BYSETPOS” “=” bysplist ) /
( “;” “WKST” “=” weekday ) /
enddate = date
enddate =/ date-time ;An UTC value
byseclist = seconds / ( seconds *(“,” seconds) )
seconds = 1DIGIT / 2DIGIT ;0 to 59
byminlist = minutes / ( minutes *(“,” minutes) )
minutes = 1DIGIT / 2DIGIT ;0 to 59
byhrlist = hour / ( hour *(“,” hour) )
hour = 1DIGIT / 2DIGIT ;0 to 23
bywdaylist = weekdaynum / ( weekdaynum *(“,” weekdaynum) )
weekdaynum = [([plus] ordwk / minus ordwk)] weekday
plus = “+”
minus = “-”
ordwk = 1DIGIT / 2DIGIT ;1 to 53
weekday = “SU” / “MO” / “TU” / “WE” / “TH” / “FR” / “SA”
Conclusion:
Syntax provided above can be used in OIC to create a complete schedule in OIC.
