Adding Job Steps in Database Update Export Jobs

Master Data Management with webMethods OneData : Implementing webMethods OneData : Exporting Data from OneData Objects : Adding Job Steps : Adding Job Steps in Database Update Export Jobs

After you create a job step, you must add a job step to the job before it can be executed. You can create a new job step or use an existing job step.

To add a job step in a database update job

1. Complete the procedure in Adding Job Steps.

2. Define the Job Step Definition properties:

Field	Description
SQL Generation Criterion	Audit Columns Only. (Recommended) Audit Columns & Check In Destination
Destination Schema and Table	Select the destination schema and table.

3. In the column mapping section, select the Destination Column that corresponds to the source column.

Note:

If the target table does not have primary key defined, you can specify the primary key on the column mapping screen in the job step definition. If the primary key is defined in the target table, OneData recognizes the key and does not provide a mapping option for the field.

4. Click Save.

Contact Support | Community | Feedback