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
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.