Skip to main content
Solved

How to schedule the IAL to run annually?


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

View original
Did this topic help you find an answer to your question?

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+20
  • Superhero (Employee)
  • 492 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings