There are two main strategies behind creating multiple MultiOutput jobs. The strategy you will use will depend on your use case.
The second strategy are segregated processing for a group of queues. This strategy refers to creating multiple jobs, each job to handle a specific queue. If you are sharing data to a large number of queues, then this is the path you should lean towards. It sets up sharing to divide the work of your outbound table into groupings based on the queue they are writing to. Since the queues are processed iteratively, this changes the workflow from 1 job processing all queues to X jobs processing their own subset of queues.
This will retain the sequencing of the data.
Procedure
To create multiple MultiOutput jobs using segregated processing for a group of queues strategy, follow these steps:
Create a filter on your current outbound messages with the following: Target Queue is queue 1 OR Target Queue is queue 2 OR Target Queue is queue 3
Then click Copy query.
Pass the encoded query into the job. It should resemble the query below containing the sys_id of the target queues selected:
u_target_queue=XXXX^ORu_target_queue=YYYY^ORu_target_queue=ZZZZ
Repeat this process for as many queue groupings as you need.
