Creating a new batch job template

To create a new batch job template, ensure that appropriate entries exist in four database tables: CDMETADATAPACKAGETP, CDMETADATAINFO_TP, TASKDEFINITION, and TASK_ROLE_ASSOC_ID.

Procedure

Edit the CDMETADATAPACKAGETP table, if necessary, to insert a record with the following values:
- METADATA_PACKAGE_TP_CD=2
- METADATA_PACKAGE_NAME=Bulk Processing Entity Search Clause
Table 1. CDMETADATAPACKAGETP table row

METADATA_PACKAGE_TP_CD METADATA_PACKAGE_NAME

2 Bulk Processing Entity Search Clause
Edit the CDMETADATAINFOTP table to insert a row with the following values:
- METADATA_INFO_TP_CD – the foreign key assigned to the TASKDEFINITION table
- METADATA_KEY – the comma-separated placeholder names that are used in your template
- METADATA_PACKAGE_TP_CD=2
Table 2. Sample CDMETADATAINFOTP table row

METADATA_INFO_TP_CD METADATA_KEY METADATA_PACKAGE_TP_CD

8 ENTITY_ID,ENTITY_TYPE,PersistenceMode 2

Table 1. CDMETADATAPACKAGETP table row
METADATA_PACKAGE_TP_CD	METADATA_PACKAGE_NAME
2	Bulk Processing Entity Search Clause

Table 2. Sample CDMETADATAINFOTP table row
METADATA_INFO_TP_CD	METADATA_KEY	METADATA_PACKAGE_TP_CD
8	ENTITY_ID,ENTITY_TYPE,PersistenceMode	2

Edit the TASKDEFINITION table to insert a row with the following values:

TASK_DEFINITION_ID – the foreign key assigned to the TASKROLEASSOC table
TASK_CAT_TP_CD=8
TASK_NAME – the name of the task type
TASK_LAUNCH_ACTION_TP_CD=3
TASK_LAUNCH_ACTION_DATA – the XML template
METADATA_INFO_TP_CD – this value comes from the CDMETADATAINFOTP record

Table 3. Sample TASKDEFINITION table row
TASK_DEFINITION_ID	TASK_CAT_TP_CD	TASK_NAME	TASK_LAUNCH_ACTION_TP_CD	TASK_LAUNCH_ACTION_DATA	METADATA_INFO_TP_CD
90	8	Persist Entities (single entity type)	3	TEMPLATE	8

Edit the TASKROLEASSOC table to insert a record with the following values:
- TASK_ROLE_ASSOC_ID – user defined
- TASK_DEFINITION_ID – this value comes from the TASKDEFINITION table
- TASK_OWNER_ROLE=Bulk Processing
Table 4. Sample TASKROLEASSOC table row

TASK_ROLE_ASSOC_ID TASK_DEFINITION_ID TASK_OWNER_ROLE

12 90 Bulk Processing

Table 4. Sample TASKROLEASSOC table row
TASK_ROLE_ASSOC_ID	TASK_DEFINITION_ID	TASK_OWNER_ROLE
12	90	Bulk Processing

What to do next

To view the request and response XML generated by your template, you must configure the batch log writer. For details, see Batch processor log files and output files.