Solved

Setting a start date for Scheduled Task to run every 14 days

  • 16 February 2023
  • 1 reply
  • 70 views

Userlevel 7
Badge +18

I need to create a scheduled task in advance that will execute every 14 days at a certain time of the day

e.g. creating a scheduled task on today 16/02/2023 that will execute every 14 days starting on 01/03/2023 so that the first execution will be 01/03/2023 and then the next execution should be 14 days after on the 15/03/2023

Selected custom and entering SYSDATE+14 in the Expression

Entered the Start Date as 01/03/2023 but on clicking calculate or saving the record the Next Execution is calculated as 02/03/2023 and the time is the same time as when the record is saved/last amended.

 

Is there a better way to achieve what I require?

It would be also be good if I could set the time as well.

Thank you.

icon

Best answer by RutJWhalen 16 February 2023, 12:21

View original

1 reply

Userlevel 7
Badge +18

I have managed to solve it.

 

The answer was to still use Custom 

But the EXPRESSION needs to be set to:

FREQ=WEEKLY INTERVAL=2

Reply