Siebel Data Quality Administration Guide > Using Siebel Data Quality >

Generating or Refreshing Keys Using Batch Jobs

The following procedure describes how to start a batch job to generate or refresh keys for data matching. For more information about how SDQ generates, refreshes, and stores keys, see Siebel Data Quality Concepts.

To start a batch job to generate or refresh keys

1. Start the Server Manager Program.
2. At the srvrmgr prompt, enter one of the commands in the following table to generate or refresh keys.

   Substitute values of your own choosing in the WHERE clauses, as needed.

   Business Component	Generate or Refresh Keys?	Example of Server Manager Command
   Account	Generate	run task for comp DQMgr with bcname=Account, bobjname=Account, opType="Key Generate", objwhereclause="[Updated] > '07/18/2005 16:00:00'"
   	Refresh	run task for comp DQMgr with bcname=Account, bobjname=Account, opType="Key Refresh", objwhereclause="[Name] LIKE 'search_string*'"
   Contact	Generate	run task for comp DQMgr with bcname=Contact, bobjname=Contact, opType="Key Generate", objwhereclause="[Updated] > '07/01/2005 14:10:00'"
   	Refresh	run task for comp DQMgr with bcname=Contact, bobjname=Contact, opType="Key Refresh", objwhereclause="[Last Name] LIKE 'search_string*'"
   List Mgmt Prospective Contact	Generate	run task for comp DQMgr with bcname="List Mgmt Prospective Contact", bobjname="List Mgmt", opType="Key Generate", objwhereclause="[Updated] > '07/18/2005 16:00:00'"
   	Refresh	run task for comp DQMgr with bcname="List Mgmt Prospective Contact", bobjname="List Mgmt", opType="Key Refresh", objwhereclause="[Last Name] LIKE 'search_string*'"

   The examples in the table show slightly different WHERE clauses for key generation and key refresh operations, as follows:

   • The generation commands generate keys for all records in the business component that have been updated since the specified date and time.
   • The refresh commands refresh keys for all records in the business component that match the search string in the specified field.

     You can use either of these two types of WHERE clauses for both generation and refresh operations.

     If you want to generate or refresh keys for all records in the business component, use a WHERE clause containing a wildcard character (*) to match all records, as follows:

   objwhereclause="[field_name] LIKE '*'"