Siebel Data Quality Administration Guide > Administering Data Quality > Matching Data Using Batch Jobs >
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. To start a batch job to generate or refresh keys
- Start the Server Manager Program.
- 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.
|
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'" |
Account |
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'" |
Contact |
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'" |
List Mgmt Prospective Contact |
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 '*'"
|