Skip to main content
Solved

How to schedule the IAL to run annually?

  • August 3, 2023
  • 4 replies
  • 167 views

Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 8 replies

Hi all, 

I need to schedule an IAL to run once a year on the 1st OCT.  Is this possible in APP10?

Many thanks,

Ben

Best answer by Tomas Ruderfelt

Here is an example how to add a condition to run at October 1st. at 03:00:00 AM every year:

FREQ=YEARLY;BYMONTH=10;BYMONTHDAY=1;BYHOUR=3;BYMINUTE=0;BYSECOND=0

 

Use the option “Custom” to be able to input your custom expression.

 

Syntax details can be found here in Oracle documentation if you are interested:

https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72260

4 replies

Thirunavukkarasu Kapilan
Hero (Partner)
Forum|alt.badge.img+10

@BMORGAN 

Hi, 

First define the IAL object using the below window.

After that, using IAL configuration window you can define the schedule to execute.
 

Best Regards,


Forum|alt.badge.img+4
  • Author
  • Sidekick (Customer)
  • 8 replies
  • August 3, 2023

@Thirunavukkarasu Kapilan

 

Thank you for your reply. I need the IAL to run on the 1st OCT every year. So, if I were to place the scheduled date to 01/10/2023 (uk = dd/mm/yyyy), will the IAL run every year on the 1st OCT or just the once?


Forum|alt.badge.img+21
  • Superhero (Employee)
  • 500 replies
  • Answer
  • August 3, 2023

Here is an example how to add a condition to run at October 1st. at 03:00:00 AM every year:

FREQ=YEARLY;BYMONTH=10;BYMONTHDAY=1;BYHOUR=3;BYMINUTE=0;BYSECOND=0

 

Use the option “Custom” to be able to input your custom expression.

 

Syntax details can be found here in Oracle documentation if you are interested:

https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72260


Forum|alt.badge.img+4
  • Author
  • Sidekick (Customer)
  • 8 replies
  • August 3, 2023

@Thirunavukkarasu Kapilan

 

Perfect. Thank you for your help.