Siebel Assignment Manager Administration Guide > Running Assignment Manager >

Running Assignment Manager in Batch Mode


This section explains how to run Assignment Manager in batch mode. Use Batch Assignment to assign an assignment object in a single batch. You must run Assignment Manager in batch mode if you change non-object data that can affect assignments. This happens whenever you:

If you run both Batch Assignment and Dynamic Assignment in your environment, the Batch Assignment can activate Dynamic Assignment due to triggers created in the database required to run Dynamic Assignment. Before running Batch Assignment, you should deactivate all assignment policies and drop related triggers to prevent Dynamic Assignment from processing modified rules, objects, and candidates. For more information, see To deactivate an assignment policy and To run Generate Triggers. After completing Batch Assignment, you can activate the assignment policies and re-enable Dynamic Assignment. For more information on batch assignment, see Batch Assignment. For more information, see To activate an assignment policy.

NOTE:  For performance reasons, do not run Batch Assignment while running Dynamic Assignment.

You can have a batch assignment task load only a particular group of rules into memory by specifying the ROW ID of the rule group in the Assignment Key parameter when you start the task. If no rule group is specified for this parameter, the batch task loads all rules in the Default Group into memory. If no rule groups have been defined in the application, then all active rules in the database load. For more information, see Assignment Rule Groups.

To run Batch Assignment

  1. From the application-level menu, choose View > Site Map > Server Component Requests > My Component Requests.
  2. In the My Component Requests form, click New.
  3. A new record appears with a system-defined ID automatically populated with a status of Creating.

  4. In the new record, enter the relevant information for the new component request.
    1. In the Components/Job field, click the select button.
    2. In the Components/Jobs dialog box, query for Batch Assignment, and then click GO.
    3. In the Server field, type the name of the server on which you want to run this batch request.
    4. Optionally, if you want to run a specific rule group for this batch, type the Row ID of the assignment rule group for which you want rules processed for the AsgnKey parameter.
    5. Complete the rest of the fields for the new record, if needed.
  5. In the Component Request Parameters list, click New to create a new record, and enter relevant information for the assignment object that you want to assign as part of this batch request.
    1. In Name field, click the select button.
    2. In the Job Parameters dialog box, select Assignment Object Name, and then click OK.
    3. In the Value field, enter the name of the assignment object for the parameter.
    4. Use the exact name found in Siebel Tools, such as Service Request or Order (Sales Credit Assignment).

      NOTE:  Because Batch Assignment cannot run more than one assignment object per batch, you should run Batch Assignment on only one assignment object for each batch.

  6. While still in the Component Request Parameters list, click New to create a new record so that Assignment Manager uses the Object WHERE clause to limit the number of rows processed at one time.
    1. In Name field, click the select button.
    2. In the Job Parameters dialog box, query for ObjWhereClause, click Go, and then click OK.
    3. In the Value field, enter a WHERE clause to select the object instance that you want to process; the WHERE clause can include up to 100 characters.
    4. For example, to select object instances beginning with ibm, type:

    WHERE name like `ibm%'

    NOTE:  If you leave the value field blank, all object instances are selected. However, it is strongly recommended that you limit the number of rows that Assignment Manager processes to make sure that sufficient rollback space is available.

    For more information about using the Object WHERE clause, see Table 33 and further description following table.

  7. Optionally, if you want to enable Contact Denormalization for Batch Assignment, add two more component request parameter records with
    values from the following table:
  8. Parameter Name
    Value
    Assignment Object Name

    Contact Denormalization

    Assignment Mode

    Denorm

  9. Optionally, if you want to save changes to the database during batch processing, add another component request parameter as follows:
    1. In Name field, click the select button.
    2. In the Job Parameters dialog box, query for Batch Size, and then click Go.
    3. In the Value field, enter the number of objects to assign before committing each batch.
  10. In the My Component Requests form, click the menu button and choose Submit request.

CAUTION:  Batch Assignment updates the ASGN_DT and timestamp fields if there is a net change (for example, if there is a change in at least one of the primaries or if there is a change in at least one of the team tables), and all columns are updated (primaries, ASGN_DT, and system columns). However, if there is no net change, only the ASGN_DT column is updated.


 Siebel Assignment Manager Administration Guide 
 Published: 18 June 2003