useful when you need to run several tasks (DL, CFS, CF, ...) in a sequence (so that they wait for each other).
Control Table
SequenceName | Order | Type | TaskName | State | LastRun |
---|---|---|---|---|---|
DM X load | 1 | DL | SalesDFtoDS | / RUNNING / DONE / ERROR | |
DM X load | 2 | DL | SalesDStoDM | ||
DM X load | 3 | DL | SalesDMCalculation |
- 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