Automate a sequence of projects

Automate a sequence of projects












Home » Resources » Here

While Lokad does its best to perform operations as fast as possible, many operations take several minutes or even more to complete. Therefore, in order to avoid keeping you waiting while the results are being computed, Lokad provides scheduling capabilities to auto-trigger processes on a scheduled basis. In addition, the process sometimes requires a whole sequence of operations to be performed in the correct order. As a result, Lokad also offers orchestration capacities to define a sequence of operations to be executed.

Project sequences

With a Lokad account, multiple types of projects can be created. In particular, it is possible to create a project sequence by clicking:

Image

This type of project can be configured for both scheduling and orchestration purposes. Once the new project is created, click Edit to start modifying your project. In particular, we suggest to change the title for a description that makes sense:

Image

Configuring the schedule

The sequence project can be executed either manually - by clicking Run like any other project - or automatically through its own execution schedule. By default, when a sequence project is created, the scheduled execution is disabled. In order to enable the scheduled execution, you should check the box Enable scheduled execution and click Save.

Image

Then, the schedule detail can be adjusted. Lokad supports two types of schedules: either daily or weekly. For each schedule, you can define the time and the applicable time zone. The time should be entered as a 24h entry (aka 13:00 is 1PM).

We typically suggest to have a master sequence that is executed every night (after midnight in the dominant time zone business-wise). This sequence starts with refreshing the data - assuming that Lokad has a data connector - and ends with the various reports. This pattern ensures that you get “fresh” Lokad numbers every morning.

Configuring the orchestration

Once the new project sequence has been created, it is possible to define the actual sequence of projects to be executed. First, you need to select the project to be part of the sequence. This can be achieved by clicking the button Add projects.

Image Each project comes with a few settings:

  • Continue if failed indicates whether the sequence should proceed with the next project in the list if the previous project has failed to complete successfully. This setting can typically be checked if the rest of the sequence has no strict dependency on the failing project.
  • Skip if more recent than N minutes is used to speed up the execution of long sequences. For example, refreshing a data source can take up to several hours, but if the data source has already been refreshed in the last 12 hours, there is no need to refresh it again.