...
We refer to the pattern that results with this type of job chain as a "diamond" pattern. Such patterns can occur more than once in a job chain: both sequentially, as shown in the diagram above, in parallel and nested. They can also be combined with other job chain patterns such as emerald or cross-over patterns (see Synchronisation_of_Job_Chainssee Example showing the synchronization of multiple job chains).
Job chain list view
The next illustration shows a list view of the job chain as produced by JOE:
...
- The splitter job state_names parameter is used to specify the node names of the jobs that are to be first started in parallel (see Setting_How to set and read job, order and node parameters).
- The node names are to be seperated by semi-colons.
- In jobs chains with this diamond pattern structure, the parameters are specified for the job chain and referred to as node parameters. Node parameters can be used to specify parameters for more than one splitter in a job chain, independently of one another, as in our example, without creating conflicts.
...
A unique sync job is required at the end of every group of processes running in parallel (see Setting_up_a_sync_job Example showing how to run parallel jobs in a job chain) when the nodes in the job chain after the sync node are only to be processed after all the jobs (tasks) that are to be carried out in parallel have been completed without errors (see Best Practice - Give each sync job a unique name).
Each sync job has to be unique within a JobScheduler instance - and within a job chain - as long as a cross-over pattern has not been implemented (see Synchronizaton of Job Chains Example showing the synchronization of multiple job chains).
For more information see the documentation for the JobSchedulerSynchronizeJobChains job.
...
- Documentation of jobs JobSchedulerSynchronizeJobChains.
- Examples for the use of sync jobs see JobScheduler FAQ - How to syncronize jobsconfigure sequential execution of jobs in parallel.
- Best Practice.
Downloads
You can download the example described in this FAQ : insert_to_export_table_parallel.zip.