Skip to main content

Workflow scheduling plans really aren't like a cron schedule

  • February 7, 2024
  • 1 reply
  • 94 views

Marcel-Jan
Star Blazer L2
Forum|alt.badge.img+1

Yes, it is clearly stated in the documentation (Scheduler - Ataccama ONE Gen2 Platform Latest), but it is also easy to overlook: scheduling plans for workflows look a bit like crontab schedules. But they aren't.

Example workflow scheduling plan:

<?xml version='1.0' encoding='UTF-8'?>

<scheduleDefinition>

        <description>ATAC_DWH - Load Dimensions and Facts</description>

        <enabled>true</enabled>

        <job workflow="myorg:ATAC_DWH_dims_and_facts.ewf" class="com.ataccama.adt.scheduler.job.WorkflowJob"/>

        <scheduling>0 20 1-5 *</scheduling>

</scheduleDefinition>

 

For example, when you want to schedule workflow Monday to Friday at 20:00 you might think “easy, I just go to crontab.guru, Fill in what I want and voila”: the schedule plan will be 0 20 * * 1-5.

Except you will notice that your workflow will also run in weekends. Because the format of the workflow scheduler is:

minutes hours day_of_week day_of_month

It has only four positions. And it will happily ignore your 1-5 (meaning Monday to Friday) on the fifth position.

So your actual scheduling plan should be: 0 20 1-5 *

 

Also, this scheduling format is different from the advanced scheduling format of monitoring projects.

The scheduler for monitoring projects actually is cron expression like.

This _is_ actually cron expression like and Ataccama even has a link to the cron expression generator  on freeformatter.com. You would be excused to think you could generate a scheduling plan for monitoring project and then copy it to your workflow scheduling plan, thinking that will work. But there formats are not the same.

 

You wouldn't be the first one to overlook this. Maybe it's time for an ataccamacrontab.guru or Ataccama scheduling plan generator or something.

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

1 reply

Cansu
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • 632 replies
  • February 12, 2024

Hi @Marcel-Jan, thank you for taking the time to share this tip and pass on the feedback on how we can make it more visible 💡


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