About Running Multiple Instances of Siebel Assignment Manager in Batch Mode

This topic is part of About Running Batch Assignment.

When there are many objects that must be assigned, you can run multiple instances of Assignment Manager in batch mode to improve performance. First, develop a strategy for specifying multiple batches using the Object Where Clause parameter in the Batch Assignment component. Then, start multiple instances of batch assignment specifying the appropriate Object Where Clause value for each instance.

For example, you can run one instance of batch assignment for accounts that changed today and a different instance of batch assignment for accounts that changed yesterday. Use the Object Where Clause parameter to specify the following:

• For the batch that processes accounts changed today:

  Object Where Clause: WHERE LAST_UPD = SYSDATE
  

• For the batch that processes accounts changed yesterday:

  Object Where Clause: WHERE LAST_UPD = SYSDATE - 1
  

  Note: These examples use a nonindexed field: LAST_UPD. It is recommended, however, that you use indexed fields for object WHERE clause statements. Also, use the appropriate database datetime functions to determine the current date and time, depending on the database that you are using. This example uses SYSDATE, which is specific to Oracle Database datetime functions.

To process mutually exclusive sets of records when running multiple instances of Assignment Manager simultaneously for the same assignment object, specify an Object Where Clause for each assignment task. You can also distribute the tasks on multiple Siebel Servers to enhance performance.