Creates a new job from one or more comparesets, schedules, and comparison options.
create job job_name set max_concurrent_comparisons [{to|=}] number_of_max_concurrent_comparisons [and set desc [{to|=}] description]] add comparison comparison_name set COMPARESET=compareset_name and set comparison_param [{to|=}] value [with column option set column_name [{to|=}] {literal | column_hash | row_hash} [set column_name [{to|=}] {literal | column_hash | row_hash}] […]] [and comparison comparison_name set COMPARESET =compareset_name and set priority [{to|=}] {highest | high | normal | low}… [with column option set column_name [{to|=}] {literal | column_hash | row_hash} [set column_name [{to|=}] {literal | column_hash | row_hash}] […]]] [add schedule schedule_name set schedule_param [{to|=}] value
create job with exist_job_name set max_concurrent_comparisons [{to|=}] number_of_max_concurrent_comparisons [add schedule schedule_name set schedule_parameters [{to|=}] value [and set desc [{to|=}] “description”] to create job job_name with exist_job_name
comparison_param | value |
---|---|
ABORT_DIFF_MAX |
Aborts row comparison if the difference count exceeds the specified value. Valid values: 1 to 9223372036854775807. Default value:1000. |
ABORT_DIFF_ROW_COUNT |
Determines whether to abort row comparison if table row counts do not match. Valid values: true or false. Default value: false. |
AUTO_RECONCILE |
Indicates whether to automatically apply the reconciliation script. Valid values: true or false. Default value: false. Note: To enable AUTO_RECONCILE, set CREATE_COL_LOG to true.
|
COMPARE_MODE |
Specifies the row comparison mode.
Default value: row_compare. |
COMPRESS_DATA_TRANSFER |
Compresses the row data between the agent and the server. Valid values: true or false. Default value: false. |
CREATE_COL_LOG |
Generates a column differences log, which lists all missing, orphaned, and inconsistent row values (keys and columns). Create a column log if you want to:
Valid values: true or false. Default value: false. |
CREATE_RECON_SCRIPT |
Generates a reconciliation script. To use this parameter, you must also set CREATE_COL_LOG to true. Valid values: true or false. Default value: false. |
ENABLE_ROW_COUNT |
Determines whether or not to count source and target table rows before they are compared. DA server uses the row count to estimate the comparison progress and end time. Note: DA server counts rows if COMPARE_MODE is row_count. Use ENABLE_ROW_COUNT only if COMPARE_MODE is a value other than row_count.
Valid values: true or false. Default value: true. |
EXTERNAL_SORT |
Sorts rows on the agent, thereby reducing the impact of processing the ORDER BY clause in the databases. Valid values: true or false. Default value: false. |
HASH_TYPE |
Specifies the hash type for the comparison.
Default value: database_hash. |
RETRY_DIFF |
Specifies the retry option.
Default value: never. |
RETRY_DELAY_SEC |
Specifies the number of seconds delay for each recomparison. Valid values: 0 to 86400. Default value: 10. |
RETRY_MAX |
Specifies the total number of recomparison for rows that have differences resulting from a previous comparison. Valid values: 0 to 100. Default value: 3. |
Column Option | Value |
---|---|
COMPARE_MODE |
Specifies for how each column is compared.
|
schedule_param | value |
---|---|
date_value |
Specifies a date in the scheduler. |
time_value |
Specifies a time in the scheduler. |
month_day_value |
Specifies the day of the month in the scheduler. |
cron_value |
Specifies the cron option value in the scheduler. |
create job myjob_1 set max_concurrent_comparisons = 3 add comparison mycomparison_1 set compareset=mycompareset_1 and set priority = high with column option and set a = literal set b = hash and comparison mycomparison_2 set compareset=mycomparset_2 and set priority = normal with schedule myschedule_1 set type=every_days and set every=2 and set time=10:00 and set keep=1 and set keep_unit=months and set date=2011-05-05 go
Job “myjob_1” was created successfully.
create job myjob_2 with myjob_1 go
Job “myjob_2” was created successfully.
The names of the comparisons in a cloned job are generated automatically (if not explicitly specified). The rule is job_name_cloned_comparison_sequence_number, where sequence_number starts from one.
When cloning jobs, you can redefine only the scheduling options. The comparison options are automatically imported from the existing job.