When you call the ConfigureDtsJob operation to configure a data migration or data synchronization task, you can set the DataCheckConfigure parameter based on your requirements.

Parameters

The data type of the DataCheckConfigure parameter is String, and the value must be specified in the JSON format. The following table describes the parameters of the DataCheckConfigure parameter.

Parameter Type Description
DataCheckDbList String The objects whose data is to be verified. The value must be a JSON string.
FullDataCheck Boolean Specifies whether to perform a full data verification task. Valid values: true and false.
FullCheckModel Integer The mode of the full data verification task. Valid values:
  • 1: verifies the data by sampling ratio.
  • 2: verifies the data by row.
FullCheckFixData Boolean Specifies whether to replace the inconsistent data. Valid values: true and false. Default value: false.
Note For example, you set this parameter to true. If the destination database has data that is inconsistent with the data in the source database, the data values of the destination database are replaced with those of the source database.
FullCheckRatio Integer The sampling ratio of the full data verification task. Valid values: integers from 10 to 100. Unit: percent.
Note This parameter is required if the FullCheckModel parameter is set to 1.
CheckMaximumHour Integer The timeout period of the full data verification task. Valid values: integers from 1 to 72. Countdown begins the moment the full data verification task is started. If the task is not complete within the specified timeout period, the task is forcibly stopped.
DataCheckNoticePhone String The mobile number of the alert contact for a full or incremental data verification task. If an alert is triggered for a verification task, a text message is sent to notify the alert contact.
FullCheckErrorNotice Boolean Specifies whether to trigger an alert if the full data verification task fails. Valid values: true and false.
Note For example, you set this parameter to true. If the full data verification task fails, an alert is triggered.
FullCheckValidFailNotice Boolean Specifies whether to trigger an alert if data inconsistency is detected by the full data verification task. Valid values: true and false.
Note For example, you set this parameter to true. If the number of inconsistent data entries detected by the full data verification task is greater than or equal to the threshold that you specified, an alert is triggered.
FullCheckNoticeValue Integer The alert threshold for inconsistent data entries detected by the full data verification task.
Note This parameter is required if the FullCheckValidFailNotice parameter is set to true.
IncrementalDataCheck Boolean Specifies whether to perform an incremental data verification task. Valid values: true and false.
IncrementalCheckErrorNotice Boolean Specifies whether to trigger an alert if the incremental data verification task fails. Valid values: true and false.
Note For example, you set this parameter to true. If the incremental data verification task fails, an alert is triggered.
IncrementalCheckValidFailNotice Boolean Specifies whether to trigger an alert if data inconsistency is detected by the incremental data verification task. Valid values: true and false.
Note For example, you set this parameter to true. If the cumulative number of inconsistent data entries detected by the incremental data verification task in several statistical periods is greater than or equal to the threshold that you specified, an alert is triggered.
IncrementalCheckValidFailNoticePeriod Integer The statistical period of an alert on inconsistent data entries detected by the incremental data verification task. Valid values:
  • 1: 1 minute
  • 2: 5 minutes
  • 3: 10 minutes
  • 4: 30 minutes
Note This parameter is required if the IncrementalCheckValidFailNotice parameter is set to true.
IncrementalCheckValidFailNoticeTimes Integer The number of statistical periods of an alert on inconsistent data entries detected by the incremental data verification task.
Note This parameter is required if the IncrementalCheckValidFailNotice parameter is set to true.
IncrementalCheckValidFailNoticeValue Integer The alert threshold for inconsistent data entries detected by the incremental data verification task.
Note This parameter is required if the IncrementalCheckValidFailNotice parameter is set to true.
IncrementalCheckDelayNotice Boolean Specifies whether to trigger an alert on the data latency of the incremental data verification task. Valid values: true and false.
Note For example, you set this parameter to true. If the cumulative latency of the incremental data verification task in several statistical periods is greater than or equal to the threshold that you specified, an alert is triggered.
IncrementalCheckDelayNoticePeriod Integer The statistical period of an alert on the data latency of the incremental data verification task. Valid values:
  • 1: 1 minute
  • 2: 5 minutes
  • 3: 10 minutes
  • 4: 30 minutes
Note This parameter is required if the IncrementalCheckDelayNotice parameter is set to true.
IncrementalCheckDelayNoticeTimes Integer The number of statistical periods of an alert on the data latency of the incremental data verification task.
Note This parameter is required if the IncrementalCheckDelayNotice parameter is set to true.
IncrementalCheckDelayNoticeValue Long The alert threshold for the data latency of the incremental data verification task. Unit: seconds.
Note This parameter is required if the IncrementalCheckDelayNotice parameter is set to true.