Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

useful when you need to run several tasks (DL, CFS, CF, ...) in a sequence (so that they wait for each other).

Control Table

SequenceNameOrderTypeTaskNameStateLastRun
DM X load1DLSalesDFtoDS/ RUNNING / DONE / ERROR
DM X load2DLSalesDStoDM

DM X load3DLSalesDMCalculation

  • SequenceName - you can have more sequences. All tasks which should run in one sequence must have the same SequenceName
  • Order - this is used to execute the tasks in correct order. When 2 or more tasks in the sequence have the same OrderOfTask number, then they will be run in parallel.
  • Type - what should be executed
  • TaskName - the name of the DL / CFS / ...
  • State - what is happening with the task.
    • <nothing> - should be executed
    • RUNNING - is running now
    • DONE - finished successfully
    • ERROR - finished with ERROR (is the task ends with ERROR, it stops the sequence)
  • LastRun - datetime of the end of last run of the task

Scheduler

is simple CFF, which is executed every minute and starts the tasks according the Control Table

Installation

  • Groovy Library - add a new element called "Sequencer", with following code: Sequencer Library Code.groovy
  • New Calculation Flow Formula, scheduled every minute, with one element with this code: 

    lib.Sequencer.processAllSequences(actionBuilder)
  • Import the Price Parameter called SequenceControlTable - the import zip file is attached here PP_SequenceControlTable_for_Import.zip

How to run your own Sequence

from your code (usually from a CFF, but generally from any code, which is allowed to modify Price Parameters) call following:

lib.Sequencer.startSequence("<your sequence name>")





  • No labels