Queries the list of Data Transmission Service (DTS) tasks and the details of each task.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes DescribeDtsJobs

The operation that you want to perform. Set the value to DescribeDtsJobs.

Type String No instance

The type of the query condition. Valid values:

  • instance: queries DTS tasks based on the ID of a DTS instance.
  • name: queries DTS tasks based on the name of a DTS instance. Fuzzy match is supported.
  • srcRds: queries DTS tasks based on the ID of an ApsaraDB RDS instance. The ApsaraDB RDS instance is the source instance of a DTS task.
  • rds: queries DTS tasks based on the ID of an ApsaraDB RDS instance. The ApsaraDB RDS instance is the destination instance of a DTS task.
Note You must set the Params parameter to specify the content of the query condition.
Params String No dtspk3f13r731m****

The content of the query condition.

Note You must set the Type parameter to specify the type of the query condition.
Region String Yes cn-hangzhou

The ID of the region in which the DTS instance resides. For more information, see List of supported regions.

Status String No Migrating

The state of the DTS task.

Valid values for a data migration task:

  • NotStarted: The task is not started.
  • Prechecking: The task is being prechecked.
  • PrecheckFailed: The task failed to pass the precheck.
  • PreCheckPass: The task passed the precheck.
  • NotConfigured: The task is not configured.
  • Migrating: The task is in progress.
  • Suspending: The task is paused.
  • MigrationFailed: The task failed.
  • Finished: The task is complete.
  • Retrying: The task is being retried.
  • Upgrade: The task is being upgraded.
  • Locked: The task is locked.
  • Downgrade: The task is being downgraded.

Valid values for a data synchronization task:

  • NotStarted: The task is not started.
  • Prechecking: The task is being prechecked.
  • PrecheckFailed: The task failed to pass the precheck.
  • PreCheckPass: The task passed the precheck.
  • NotConfigured: The task is not configured.
  • Initializing: The task is being initialized.
  • InitializeFailed: Initialization failed.
  • Synchronizing: The task is in progress.
  • Failed: The task failed.
  • Suspending: The task is paused.
  • Modifying: The objects in the task are being modified.
  • Finished: The task is complete.
  • Retrying: The task is being retried.
  • Upgrade: The task is being upgraded.
  • Locked: The task is locked.
  • Downgrade: The task is being downgraded.

Valid values for a change tracking task:

  • NotConfigured: The task is not configured.
  • NotStarted: The task is not started.
  • Prechecking: The task is being prechecked.
  • PrecheckFailed: The task failed to pass the precheck.
  • PreCheckPass: The task passed the precheck.
  • Starting: The task is being started.
  • Normal: The task is running as expected.
  • Retrying: The task is being retried.
  • Abnormal: The task is not running as expected.
  • Upgrade: The task is being upgraded.
  • Locked: The task is locked.
  • Downgrade: The task is being downgraded.
OrderDirection String No ASC

The order in which the returned DTS tasks are sorted. Valid values:

  • ASC: sorts the DTS tasks in ascending order. This is the default value.
  • DESC: sorts the DTS tasks in descending order.
OrderColumn String No CreateTime

The basis on which the returned DTS tasks are sorted. Valid values:

  • CreateTime: sorts the DTS tasks based on the points in time when the DTS tasks are created.
  • FinishTime: sorts the DTS tasks based on the points in time when the DTS tasks are complete.
  • duLimit sorts the DTS tasks based on the upper limits on DTS Units (DUs) that the DTS tasks can use. This option applies only to the DTS tasks that are run on a DTS dedicated cluster.
Note You can also set the OrderDirection parameter to specify whether to sort the DTS tasks in ascending or descending order.
Tags String No [ { \"key\": \"testK\", \"value\": \"testV\" } ]

The tags of the DTS task to be queried. Specify tags in the JSON format.

Note You can call the ListTagResources operation to query the tag key and tag value.
PageSize Integer No 30

The number of entries to return on each page. Valid values: 30, 50, and 100. Default value: 30.

PageNumber Integer No 1

The number of the page to return. The value must be an integer that is greater than 0 and does not exceed the maximum value of the Integer data type. Default value: 1.

JobType String No MIGRATION

The type of the DTS task. Valid values:

  • MIGRATION: data migration. This is the default value.
  • SYNC: data synchronization.
  • SUBSCRIBE: change tracking.
RegionId String No No default value

This parameter is discontinued.

GroupId String No pk13r731m****

The ID of the parent task.

Note In most cases, you do not need to specify this parameter.
DedicatedClusterId String No dtscluster_atyl3b5214uk***

The ID of the DTS dedicated cluster on which the task runs.

DtsJobId String No qa110wq5r93hb49

The ID of the data migration, data synchronization, or change tracking task.

Response parameters

Parameter Type Example Description
HttpStatusCode Integer 200

The HTTP status code.

RequestId String 621BB4F8-3016-4FAA-8D5A-5D3163CC****

The ID of the request.

ErrCode String InternalError

The error code returned if the call failed.

Success Boolean true

Indicates whether the call was successful.

PageRecordCount Integer 20

The number of entries returned per page.

TotalRecordCount Integer 15

The total number of DTS tasks that meet the query condition.

ErrMessage String The Value of Input Parameter %s is not valid.

The error message returned if the call failed.

DynamicMessage String Type

The dynamic part in the error message. The value of this parameter is used to replace the %s variable in the value of the ErrMessage parameter.

Note For example, if the value of the ErrMessage parameter is The Value of Input Parameter %s is not valid and the value of the DynamicMessage parameter is Type, the specified Type parameter is invalid.
PageNumber Integer 2

The page number of the returned page.

DynamicCode String 403

The dynamic error code. This parameter will be removed in the future.

DtsJobList Array of DtsJobStatus

The list of DTS tasks and the details of each task.

Status String Migrating

The state of the DTS instance. For more information about the valid values, see the description of the request parameter Status.

OriginType String DTS

The source of the task. Valid values:

  • PTS
  • DMS
  • DTS
DtsJobName String RDS_TO_RDS_MIGRATION

The name of the data migration, data synchronization, or change tracking task.

Delay Long 0

The latency of incremental data migration or synchronization.

Note For data migration tasks, the unit of this parameter is milliseconds. For data synchronization tasks, the unit of this parameter is seconds.
ErrorMessage String DTS-070211: Connect Source DB failed. cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times. Giving up.][com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.][java.net.ConnectException:Connection timed out (Connection timed out)] About more information in [https://yq.aliyun.com/articles/499178].

The error message returned if the task failed.

ExpireTime String 2022-03-16T08:01:19Z

The point in time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

Note This parameter is returned only if the value of the PayType parameter is PrePaid.
DtsJobId String i03e3zty16i****

The ID of the data migration, data synchronization, or change tracking task.

CreateTime String 2021-03-16T08:01:19Z

The point in time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

PayType String PrePaid

The billing method of the DTS instance. Valid values:

  • PrePaid: subscription
  • PostPaid: pay-as-you-go
Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

The reserved parameter of DTS. The value is a JSON string. You can specify this parameter to meet specific requirements, for example, whether to automatically start a precheck. For more information, see MigrationReserved.

ConsumptionClient String 114...:dts******

The downstream client information, in the following format: <IP address of the downstream client>:<Random ID generated by DTS>.

DbObject String {"dtstestdata": { "name": "dtstestdata", "all": true }}

The objects of the data migration, data synchronization, or change tracking task. For more information, see Objects of DTS tasks.

DtsJobClass String large

The instance class.

Note For more information about the test performance of each instance class, see Specifications of data migration instances and Specifications of data synchronization instances.
ConsumptionCheckpoint String 2021-03-23T07:30:31Z

The consumption checkpoint of the change tracking instance. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

EndTimestamp String 2021-03-26T14:03:21Z

The end of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

AppName String new

Indicates whether the new change tracking feature is used.

Note This parameter is returned only for change tracking instances of the new version.
BeginTimestamp String 2021-03-15T08:25:34Z

The start of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

DtsInstanceID String dtsi03e3zty16i****

The ID of the data migration, data synchronization, or change tracking instance.

DtsJobDirection String Forward

The synchronization direction. Valid values:

  • Forward
  • Reverse
Note This parameter is returned only if the topology of the data synchronization instance is two-way synchronization.
Checkpoint String 1616899019

The start offset of incremental data migration or data synchronization. The value is a UNIX timestamp representing the number of seconds that have elapsed since the epoch time January 1, 1970, 00:00:00 UTC.

TagList Array of DtsTag

The tags of the task.

TagValue String testvalue

The value of the tag.

TagKey String testkey

The key of the tag.

DataInitializationStatus Object

The state of full data migration or synchronization.

Status String Finished

The state of full data migration or synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of full data migration or synchronization. This is expressed as a percentage.

ErrorMessage String java.lang.NumberFormatException: For input string: ""

The error message returned if full data migration or synchronization failed.

Progress String 44755

The number of records that have been migrated or synchronized during full data migration or synchronization.

DataSynchronizationStatus Object

The state of incremental data migration or synchronization.

Status String Catched

The state of incremental data migration or synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
  • Catched: The task is not delayed.
NeedUpgrade Boolean true

Indicates whether the instance needs to be upgraded. Valid values:

  • true: yes
  • false: no
Note To upgrade a DTS instance, call the TransferInstanceClass operation.
Percent String 95

The progress of incremental data migration or synchronization.

Progress String 0/0

The number of records that have been migrated or synchronized during incremental data migration or synchronization.

ErrorMessage String The task has failed for a long time and cannot be recovered.

The error message returned if incremental data migration or synchronization failed.

DataEtlStatus Object

The state of the extract, transform, and load (ETL) task. Valid values:

Note This parameter collection is returned only if an ETL task is configured.
Status String Finished

The state of the ETL task. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
  • Catched: The task is not delayed.
Percent String 95

The progress of the ETL task.

ErrorMessage String The task has failed for a long time and cannot be recovered.

The error message returned if the task failed.

Progress String 0/0

The number of records that have been processed by the ETL task.

DestinationEndpoint Object

The connection settings of the destination instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the destination instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the destination instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the migration object in the destination instance belongs.

Ip String 172.16.88.***

The endpoint of the destination instance.

InstanceID String rm-bp1imrtn6fq7h****

The ID of the destination instance.

Port String 3306

The database service port of the destination instance.

InstanceType String RDS

The type of the destination instance.

UserName String dtstest

The database account of the destination instance.

EngineName String MySQL

The database type of the destination instance.

MigrationMode Object

The migration or synchronization modes.

DataInitialization Boolean true

Indicates whether full data migration or synchronization is performed. Valid values:

  • true: yes
  • false: no
DataSynchronization Boolean true

Indicates whether incremental data migration or synchronization is performed. Valid values:

  • true: yes
  • false: no
StructureInitialization Boolean true

Indicates whether schema migration or schema synchronization is performed. Valid values:

  • true: yes
  • false: no
Performance Object

The performance of the data migration or synchronization instance.

Rps String 100

The number of times that SQL statements are migrated or synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

Flow String 1

The size of data that is migrated or synchronized per second. Unit: MB/s.

PrecheckStatus Object

The precheck state.

Status String Finished

The precheck status. Valid values:

  • NotStarted
  • Suspending:
  • Checking
  • Failed
  • Finished
Percent String 100

The precheck progress. This is expressed as a percentage.

ErrorMessage String CHECK__ERROR_SAME_OBJ.

The cause of the precheck failure.

Detail Array of PrecheckDetail

The result of each precheck item.

CheckResult String Success

The precheck result. Valid values:

  • Success
  • Failed
CheckItemDescription String CHECK_CONN_SRC_DETAIL

The description of the precheck item.

CheckItem String CHECK_CONN_SRC

The name of the precheck item.

RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

The method to fix the precheck failure.

Note This parameter is returned only if the value of the CheckResult parameter is Failed.
FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

The error message returned if the task failed to pass the precheck.

Note This parameter is returned only if the value of the CheckResult parameter is Failed.
ReverseJob Object

The details of the data synchronization task in the reverse direction.

Note This parameter is returned only for two-way data synchronization tasks.
Status String Synchronizing

The state of the DTS instance. For more information about the valid values, see the description of the request parameter Status.

DtsJobName String RDS_TO_RDS_MIGRATION

The name of the data synchronization task.

Delay Long 0

The latency of incremental data synchronization. Unit: seconds.

ErrorMessage String DTS-070211: Connect Source DB failed. cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times. Giving up.][com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.][java.net.ConnectException:Connection timed out (Connection timed out)] About more information in [https://yq.aliyun.com/articles/499178].

The error message returned if the task failed.

DtsJobId String i03e3zty16i****

The ID of the data synchronization task.

ExpireTime String 2022-03-16T08:01:19Z

The point in time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

Note This parameter is returned only if the value of the PayType parameter is PrePaid.
CreateTime String 2021-03-16T08:01:19Z

The point in time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

PayType String PostPaid

The billing method of the DTS instance. Valid values:

  • PrePaid: subscription
  • PostPaid: pay-as-you-go
Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

The reserved parameter of DTS. The value is a JSON string. You can specify this parameter to meet specific requirements, for example, whether to automatically start a precheck. For more information, see MigrationReserved.

DbObject String {"dtstestdata": { "name": "dtstestdata", "all": true }}

The objects that you want to synchronize. The value is a JSON string and can contain regular expressions. For more information, see "Objects of DTS tasks".

DtsJobClass String large

The instance class.

Note For more information about the test performance of each instance class, see Specifications of data synchronization instances.
DtsInstanceID String dtsi03e3zty16i****

The ID of the data synchronization instance.

DtsJobDirection String Reverse

The synchronization direction. The value is Reverse.

Checkpoint String 1616980369

The start offset of incremental data synchronization. The value is a UNIX timestamp representing the number of seconds that have elapsed since the epoch time January 1, 1970, 00:00:00 UTC.

DataInitializationStatus Object

The state of full data synchronization.

Status String Finished

The state of full data synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of full data synchronization. This is expressed as a percentage.

ErrorMessage String java.lang.NumberFormatException: For input string: ""

The error message returned if full data synchronization failed.

Progress String 43071

The number of records that have been synchronized during full data synchronization.

DataSynchronizationStatus Object

The state of incremental data synchronization.

Status String Migrating

The state of incremental data synchronization.

NeedUpgrade Boolean true

Indicates whether the instance needs to be upgraded. Valid values:

  • true: yes
  • false: no
Note To upgrade a DTS instance, call the TransferInstanceClass operation.
Percent String 100

The progress of incremental data synchronization. This is expressed as a percentage.

Progress String 20001

The number of records that have been migrated or synchronized during incremental data migration or synchronization.

ErrorMessage String The task has failed for a long time and cannot be recovered.

The error message returned if incremental data synchronization failed.

DestinationEndpoint Object

The connection settings of the destination instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the destination instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the destination instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the synchronization object in the destination instance belongs.

Ip String 172.16.88.***

The endpoint of the destination instance.

InstanceID String rm-bp1162kryivb8****

The ID of the destination instance.

Port String 3306

The database service port of the destination instance.

InstanceType String RDS

The type of the destination instance.

UserName String dtstest

The database account of the destination instance.

EngineName String MySQL

The database type of the destination instance.

MigrationMode Object

The synchronization types.

DataInitialization Boolean true

Indicates whether full data synchronization is performed. Valid values:

  • true: yes
  • false: no
DataSynchronization Boolean true

Indicates whether incremental data synchronization is performed. Valid values:

  • true: yes
  • false: no
StructureInitialization Boolean true

Indicates whether schema synchronization is performed. Valid values:

  • true: yes
  • false: no
Performance Object

The performance of the data synchronization instance.

Rps String 100

The number of times that SQL statements are synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

Flow String 1

The size of data that is synchronized per second. Unit: MB/s.

PrecheckStatus Object

The precheck state.

Status String Finished

The precheck status. Valid values:

  • NotStarted
  • Suspending:
  • Checking
  • Failed
  • Finished
Percent String 100

The precheck progress. This is expressed as a percentage.

ErrorMessage String CHECK__ERROR_SAME_OBJ.

The cause of the precheck failure.

Detail Array of PrecheckDetail

The result of each precheck item.

CheckResult String Success

The precheck result. Valid values:

  • Success
  • Failed
CheckItemDescription String CHECK_CONN_SRC_DETAIL

The description of the precheck item.

CheckItem String CHECK_CONN_SRC

The name of the precheck item.

RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

The method to fix the precheck failure.

FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

The error message returned if the task failed to pass the precheck.

SourceEndpoint Object

The connection settings of the source instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the source instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the source instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the migration object in the source instance belongs.

Ip String 172.16.88.***

The endpoint of the source instance.

InstanceID String rm-bp1imrtn6fq7h****

The ID of the source instance.

Port String 3306

The database service port of the source instance.

InstanceType String RDS

The type of the source instance.

UserName String dtstest

The database account of the source instance.

EngineName String MySQL

The database type of the source instance.

StructureInitializationStatus Object

The state of schema synchronization.

Status String Finished

The state of schema synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of schema synchronization. This is expressed as a percentage.

ErrorMessage String DTS-1020042 Execute sql error sql: ERROR: type "geometry" does not exist;

The error message returned if schema synchronization failed.

Progress String 1

The number of tables whose schemas have been synchronized.

DuUsage Long 15

The number of DUs that have been used.

CpuUsage String 90

The CPU utilization of the instance. Unit: %.

MemUsage String 500

The memory that has been used. Unit: MB.

DedicatedClusterId String dtscluster_dpwl3**********

The ID of the DTS dedicated cluster on which the task runs.

SourceEndpoint Object

The connection settings of the source instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the source instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the source instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the migration object in the source instance belongs.

Ip String 172.16.88.***

The endpoint of the source instance.

InstanceID String rm-bp1162kryivb8****

The ID of the source instance.

Port String 3306

The database service port of the source instance.

InstanceType String RDS

The type of the source instance.

UserName String dtstest

The database account of the source instance.

EngineName String MySQL

The database type of the source instance.

StructureInitializationStatus Object

The state of schema migration or schema synchronization.

Status String Finished

The state of schema migration or schema synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of schema migration or schema synchronization. This is expressed as a percentage.

ErrorMessage String DTS-1020042 Execute sql error sql: ERROR: type "geometry" does not exist;

The error message returned if schema migration or schema synchronization failed.

Progress String 1

The number of tables whose schemas have been migrated or synchronized.

RetryState Object

The information about the retries performed by DTS due to an exception.

RetryCount Integer 5

The number of retries that have been performed.

MaxRetryTime Integer 7200

The maximum period during which retries can be performed. Unit: seconds.

ErrMessage String Unexpected error

The error message returned if the retries failed.

RetryTarget String srcDB

The object on which the retries are performed. Valid values:

  • srcDB: the source database.
  • destDB: the destination database.
  • inner_module: an internal module of DTS.
RetryTime Integer 3600

The time that has elapsed from the point in time when the first retry starts. Unit: seconds.

JobType String MIGRATION

The type of the DTS task.

DuUsage Long 15

The number of DUs that have been used.

CpuUsage String 1

The CPU utilization of the instance. Unit: %.

MemUsage String 500

The memory that has been used. Unit: MB.

DedicatedClusterId String dtscluster_ft7y3**********

The ID of the DTS dedicated cluster on which the task runs.

EtlDemoList Array of DtsJobStatus

The list of DTS tasks and the details of each task.

Status String Migrating

The state of the DTS instance. For more information about the valid values, see the description of the request parameter Status.

OriginType String DTS

The source of the task. Valid values:

  • PTS
  • DMS
  • DTS
DtsJobName String RDS_TO_RDS_MIGRATION

The name of the data migration, data synchronization, or change tracking task.

Delay Long 0

The latency of incremental data migration or synchronization.

Note For data migration tasks, the unit of this parameter is milliseconds. For data synchronization tasks, the unit of this parameter is seconds.
ErrorMessage String DTS-070211: Connect Source DB failed. cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times. Giving up.][com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.][java.net.ConnectException:Connection timed out (Connection timed out)] About more information in [https://yq.aliyun.com/articles/499178].

The error message returned if the task failed.

ExpireTime String 2022-03-16T08:01:19Z

The point in time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

Note This parameter is returned only if the value of the PayType parameter is PrePaid.
DtsJobId String i03e3zty16i****

The ID of the data migration, data synchronization, or change tracking task.

CreateTime String 2021-03-16T08:01:19Z

The point in time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

PayType String PrePaid

The billing method of the DTS instance. Valid values:

  • PrePaid: subscription
  • PostPaid: pay-as-you-go
Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

The reserved parameter of DTS. The value is a JSON string. You can specify this parameter to meet specific requirements, for example, whether to automatically start a precheck. For more information, see MigrationReserved.

ConsumptionClient String 114...:dts******

The downstream client information, in the following format: <IP address of the downstream client>:<Random ID generated by DTS>.

DbObject String {"dtstestdata": { "name": "dtstestdata", "all": true }}

The objects of the data migration, data synchronization, or change tracking task. For more information, see Objects of DTS tasks.

DtsJobClass String large

The instance class.

Note For more information about the test performance of each instance class, see Specifications of data migration instances and Specifications of data synchronization instances.
ConsumptionCheckpoint String 2021-03-23T07:30:31Z

The consumption checkpoint of the change tracking instance. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

EndTimestamp String 2021-03-26T14:03:21Z

The end of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

AppName String new

Indicates whether the new change tracking feature is used.

Note This parameter is returned only for change tracking instances of the new version.
BeginTimestamp String 2021-03-15T08:25:34Z

The start of the time range for change tracking. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

DtsInstanceID String dtsi03e3zty16i****

The ID of the data migration, data synchronization, or change tracking instance.

DtsJobDirection String Forward

The synchronization direction. Valid values:

  • Forward
  • Reverse
Note This parameter is returned only if the topology of the data synchronization instance is two-way synchronization.
Checkpoint String 1616899019

The start offset of incremental data migration or data synchronization. The value is a UNIX timestamp representing the number of seconds that have elapsed since the epoch time January 1, 1970, 00:00:00 UTC.

TagList Array of DtsTag

The tags of the task.

TagValue String testvalue

The value of the tag

TagKey String testkey

The key of the tag.

DataInitializationStatus Object

The state of full data migration or synchronization.

Status String Finished

The state of full data migration or synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of full data migration or synchronization. This is expressed as a percentage.

ErrorMessage String java.lang.NumberFormatException: For input string: ""

The error message returned if full data migration or synchronization failed.

Progress String 44755

The number of records that have been migrated or synchronized during full data migration or synchronization.

DataSynchronizationStatus Object

The state of incremental data migration or synchronization.

Status String Catched

The state of incremental data migration or synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
  • Catched: The task is not delayed.
NeedUpgrade Boolean true

Indicates whether the instance needs to be upgraded. Valid values:

  • true: yes
  • false: no
Note To upgrade a DTS instance, call the TransferInstanceClass operation.
Percent String 95

The progress of incremental data migration or synchronization.

Progress String 0/0

The number of records that have been migrated or synchronized during incremental data migration or synchronization.

ErrorMessage String The task has failed for a long time and cannot be recovered.

The error message returned if incremental data migration or synchronization failed.

DataEtlStatus Object

The state of the ETL task. Valid values:

Note This parameter collection is returned only if an ETL task is configured.
Status String Finished

The state of the ETL task. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
  • Catched: The task is not delayed.
Percent String 95

The progress of the ETL task.

ErrorMessage String The task has failed for a long time and cannot be recovered.

The error message returned if the task failed.

Progress String 0/0

The number of records that have been processed by the ETL task.

DestinationEndpoint Object

The connection settings of the destination instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the destination instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the destination instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the migration object in the destination instance belongs.

Ip String 172.16.88.***

The endpoint of the destination instance.

InstanceID String rm-bp1imrtn6fq7h****

The ID of the destination instance.

Port String 3306

The database service port of the destination instance.

InstanceType String RDS

The type of the destination instance.

UserName String dtstest

The database account of the destination instance.

EngineName String MySQL

The database type of the destination instance.

MigrationMode Object

The migration or synchronization modes.

DataInitialization Boolean true

Indicates whether full data migration or synchronization is performed. Valid values:

  • true: yes
  • false: no
DataSynchronization Boolean true

Indicates whether incremental data migration or synchronization is performed. Valid values:

  • true: yes
  • false: no
StructureInitialization Boolean true

Indicates whether schema migration or schema synchronization is performed. Valid values:

  • true: yes
  • false: no
Performance Object

The performance of the data migration or synchronization instance.

Rps String 100

The number of times that SQL statements are migrated or synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

Flow String 1

The size of data that is migrated or synchronized per second. Unit: MB/s.

PrecheckStatus Object

The precheck state.

Status String Finished

The precheck status. Valid values:

  • NotStarted
  • Suspending:
  • Checking
  • Failed
  • Finished
Percent String 100

The precheck progress. This is expressed as a percentage.

ErrorMessage String CHECK__ERROR_SAME_OBJ.

The cause of the precheck failure.

Detail Array of PrecheckDetail

The result of each precheck item.

CheckResult String Success

The precheck result. Valid values:

  • Success
  • Failed
CheckItemDescription String CHECK_CONN_SRC_DETAIL

The description of the precheck item.

CheckItem String CHECK_CONN_SRC

The name of the precheck item.

RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

The method to fix the precheck failure.

Note This parameter is returned only if the value of the CheckResult parameter is Failed.
FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

The error message returned if the task failed to pass the precheck.

Note This parameter is returned only if the value of the CheckResult parameter is Failed.
ReverseJob Object

The details of the data synchronization task in the reverse direction.

Note This parameter is returned only for two-way data synchronization tasks.
Status String Synchronizing

The state of the DTS instance. For more information about the valid values, see the description of the request parameter Status.

DtsJobName String RDS_TO_RDS_MIGRATION

The name of the data synchronization task.

Delay Long 0

The latency of incremental data synchronization. Unit: seconds.

ErrorMessage String DTS-070211: Connect Source DB failed. cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times. Giving up.][com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.][java.net.ConnectException:Connection timed out (Connection timed out)] About more information in [https://yq.aliyun.com/articles/499178].

The error message returned if the task failed.

DtsJobId String i03e3zty16i****

The ID of the data synchronization task.

ExpireTime String 2022-03-16T08:01:19Z

The point in time when the instance expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

Note This parameter is returned only if the value of the PayType parameter is PrePaid.
CreateTime String 2021-03-16T08:01:19Z

The point in time when the task was created. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

PayType String PostPaid

The billing method of the DTS instance. Valid values:

  • PrePaid: subscription
  • PostPaid: pay-as-you-go
Reserved String {\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}

The reserved parameter of DTS. The value is a JSON string. You can specify this parameter to meet specific requirements, for example, whether to automatically start a precheck. For more information, see MigrationReserved.

DbObject String {"dtstestdata": { "name": "dtstestdata", "all": true }}

The objects that you want to synchronize. The value is a JSON string and can contain regular expressions. For more information, see "Objects of DTS tasks".

DtsJobClass String large

The instance class.

Note For more information about the test performance of each instance class, see Specifications of data synchronization instances.
DtsInstanceID String dtsi03e3zty16i****

The ID of the data synchronization instance.

DtsJobDirection String Reverse

The synchronization direction. The value is Reverse.

Checkpoint String 1616980369

The start offset of incremental data synchronization. The value is a UNIX timestamp representing the number of seconds that have elapsed since the epoch time January 1, 1970, 00:00:00 UTC.

DataInitializationStatus Object

The state of full data synchronization.

Status String Finished

The state of full data synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of full data synchronization. This is expressed as a percentage.

ErrorMessage String java.lang.NumberFormatException: For input string: ""

The error message returned if full data synchronization failed.

Progress String 43071

The number of records that have been synchronized during full data synchronization.

DataSynchronizationStatus Object

The state of incremental data synchronization.

Status String Migrating

The state of incremental data synchronization.

NeedUpgrade Boolean true

Indicates whether the instance needs to be upgraded. Valid values:

  • true: yes
  • false: no
Note To upgrade a DTS instance, call the TransferInstanceClass operation.
Percent String 100

The progress of incremental data synchronization. This is expressed as a percentage.

Progress String 20001

The number of records that have been migrated or synchronized during incremental data migration or synchronization.

ErrorMessage String The task has failed for a long time and cannot be recovered.

The error message returned if incremental data synchronization failed.

DestinationEndpoint Object

The connection settings of the destination instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the destination instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the destination instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the synchronization object in the destination instance belongs.

Ip String 172.16.88.***

The endpoint of the destination instance.

InstanceID String rm-bp1162kryivb8****

The ID of the destination instance.

Port String 3306

The database service port of the destination instance.

InstanceType String RDS

The type of the destination instance.

UserName String dtstest

The database account of the destination instance.

EngineName String MySQL

The database type of the destination instance.

MigrationMode Object

The migration or synchronization modes.

DataInitialization Boolean true

Indicates whether full data migration or synchronization is performed. Valid values:

  • true: yes
  • false: no
DataSynchronization Boolean true

Indicates whether incremental data migration or synchronization is performed. Valid values:

  • true: yes
  • false: no
StructureInitialization Boolean true

Indicates whether schema migration or schema synchronization is performed. Valid values:

  • true: yes
  • false: no
Performance Object

The performance of the data migration or synchronization instance.

Rps String 100

The number of times that SQL statements are migrated or synchronized per second, including BEGIN, COMMIT, DML, and DDL statements. DML statements include INSERT, DELETE, and UPDATE.

Flow String 1

The size of data that is migrated or synchronized per second. Unit: MB/s.

PrecheckStatus Object

The precheck state.

Status String Finished

The precheck status. Valid values:

  • NotStarted
  • Suspending:
  • Checking
  • Failed
  • Finished
Percent String 100

The precheck progress. This is expressed as a percentage.

ErrorMessage String CHECK__ERROR_SAME_OBJ

The cause of the precheck failure.

Detail Array of PrecheckDetail

The result of each precheck item.

CheckResult String Success

The precheck result. Valid values:

  • Success
  • Failed
CheckItemDescription String CHECK_CONN_SRC_DETAIL

The description of the precheck item.

CheckItem String CHECK_CONN_SRC

The name of the precheck item.

RepairMethod String CHECK_ERROR_DEST_CONN_REPAIR2

The method to fix the precheck failure.

Note This parameter is returned only if the value of the CheckResult parameter is Failed.
FailedReason String Original error: Access denied for user 'dtstest'@'100.104.***.**' (using password: YES)

The error message returned if the task failed to pass the precheck.

Note This parameter is returned only if the value of the CheckResult parameter is Failed.
SourceEndpoint Object

The connection settings of the source instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the source instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the source instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the migration object in the source instance belongs.

Ip String 172.16.88.***

The endpoint of the source instance.

InstanceID String rm-bp1imrtn6fq7h****

The ID of the source instance.

Port String 3306

The database service port of the source instance.

InstanceType String RDS

The type of the source instance.

UserName String dtstest

The database account of the source instance.

EngineName String MySQL

The database type of the source instance.

StructureInitializationStatus Object

The state of schema synchronization.

Status String Finished

The state of schema synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of schema synchronization. This is expressed as a percentage.

ErrorMessage String DTS-1020042 Execute sql error sql: ERROR: type "geometry" does not exist;

The error message returned if schema synchronization failed.

Progress String 1

The number of tables whose schemas have been synchronized.

SourceEndpoint Object

The connection settings of the source instance.

SslSolutionEnum String DISABLE

Indicates whether SSL encryption is enabled. Valid values:

  • DISABLE: SSL encryption is disabled.
  • ENABLE_WITH_CERTIFICATE: SSL encryption is enabled, and the CA certificate is uploaded.
  • ENABLE_ONLY_4_MONGODB_ALTAS: SSL encryption is enabled for the connection to an AWS MongoDB Altas database.
  • ENABLE_ONLY_4_KAFKA_SCRAM_SHA_256: SCRAM-SHA-256 is used to encrypt the connection to a Kafka cluster.
OracleSID String testsid

The SID of the Oracle database.

Note This parameter is returned only if the EngineName parameter of the source instance is set to Oracle and the Oracle database is deployed in a non-RAC architecture.
Region String cn-hangzhou

The ID of the region in which the source instance resides. For more information, see List of supported regions.

DatabaseName String dtstestdata

The name of the database to which the migration object in the source instance belongs.

Ip String 172.16.88.***

The endpoint of the source instance.

InstanceID String rm-bp1162kryivb8****

The ID of the source instance.

Port String 3306

The database service port of the source instance.

InstanceType String RDS

The type of the source instance.

UserName String dtstest

The database account of the source instance.

EngineName String MySQL

The database type of the source instance.

StructureInitializationStatus Object

The state of schema migration or schema synchronization.

Status String Finished

The state of schema migration or schema synchronization. Valid values:

  • NotStarted: The task is not started.
  • Migrating: The task is in progress.
  • Failed: The task failed.
  • Finished: The task is complete.
Percent String 100

The progress of schema migration or schema synchronization. This is expressed as a percentage.

ErrorMessage String DTS-1020042 Execute sql error sql: ERROR: type "geometry" does not exist;

The error message returned if schema migration or schema synchronization failed.

Progress String 1

The number of tables whose schemas have been migrated or synchronized.

RetryState Object

The information about the retries performed by DTS due to an exception.

RetryCount Integer 5

The number of retries that have been performed.

MaxRetryTime Integer 7200

The maximum period during which retries can be performed. Unit: seconds.

ErrMessage String Unexpected error

The error message returned if the retries failed.

RetryTarget String srcDB

The object on which the retries are performed. Valid values:

  • srcDB: the source database.
  • destDB: the destination database.
  • inner_module: an internal module of DTS.
RetryTime Integer 3600

The time that has elapsed from the point in time when the first retry starts. Unit: seconds.

JobType String MIGRATION

The type of the DTS task. Valid values:

  • MIGRATION: data migration. This is the default value.
  • SYNC: data synchronization.
  • SUBSCRIBE: change tracking.

Examples

Sample requests

http(s)://dts.aliyuncs.com/?Action=DescribeDtsJobs
&Region=cn-hangzhou
&<Common request parameters>

Sample success responses

XML format

HTTP/1.1 200 OK
Content-Type:application/xml

<DescribeDtsJobsResponse>
    <TotalRecordCount>15</TotalRecordCount>
    <PageRecordCount>1</PageRecordCount>
    <DtsJobList>
        <Status>Migrating</Status>
        <DataInitializationStatus>
            <Status>Finished</Status>
            <Progress>44755</Progress>
            <Percent>100</Percent>
        </DataInitializationStatus>
        <DbObject>{"DTSTEST":{"name":"dtstest","all":true,"state":"normal","edit":false}}</DbObject>
        <CreateTime>2021-03-16T08:01:19Z</CreateTime>
        <DtsJobName>RDS_TO_RDS_MIGRATION</DtsJobName>
        <ReverseJob>
            <PrecheckStatus/>
            <DataInitializationStatus/>
            <DestinationEndpoint/>
            <SourceEndpoint/>
            <Performance/>
            <MigrationMode/>
            <StructureInitializationStatus/>
            <DataSynchronizationStatus/>
        </ReverseJob>
        <PayType>PrePaid</PayType>
        <DtsInstanceID>dtsi03e3zty16i****</DtsInstanceID>
        <Delay>0</Delay>
        <MigrationMode>
            <DataInitialization>true</DataInitialization>
            <DataSynchronization>true</DataSynchronization>
            <StructureInitialization>true</StructureInitialization>
        </MigrationMode>
        <PrecheckStatus>
            <Status>Finished</Status>
            <Percent>100</Percent>
            <Detail>
                <CheckItem>CHECK_CONN_SRC</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_CONN_SRC_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_CONN_DEST</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_CONN_DEST_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_AUTH_SRC</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_AUTH_SRC_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_AUTH_DEST</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_AUTH_DEST_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_BINLOG_ON</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_BINLOG_ON_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_BINLOG_MODE</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_BINLOG_MODE_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_BINLOG_ROW_IMAGE</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_BINLOG_ROW_IMAGE_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_SERVER_ID</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_SERVER_ID_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_BINLOG_EXIST</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_BINLOG_EXIST_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_ENGINE</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_ENGINE_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_MYSQL_PASSOWRD_FORMAT</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_MYSQL_PASSOWRD_FORMAT_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_SRC</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_SRC_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_SAME_OBJ</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_SAME_OBJ_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_SQL_MODE</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_SQL_MODE_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_SAME_USER</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_SAME_USER_DETAIL</CheckItemDescription>
            </Detail>
            <Detail>
                <CheckItem>CHECK_TOPOLOGY</CheckItem>
                <CheckResult>Success</CheckResult>
                <CheckItemDescription>CHECK_TOPOLOGY_DETAIL</CheckItemDescription>
            </Detail>
        </PrecheckStatus>
        <DtsJobClass>large</DtsJobClass>
        <Checkpoint>1616902385</Checkpoint>
        <DtsJobId>i03e3zty16i****</DtsJobId>
        <DestinationEndpoint>
            <UserName>dtstest</UserName>
            <InstanceID>rm-bp1imrtn6fq7h****</InstanceID>
            <SslSolutionEnum>DISABLE</SslSolutionEnum>
            <Port>3306</Port>
            <DatabaseName/>
            <Region>cn-hangzhou</Region>
            <InstanceType>RDS</InstanceType>
            <EngineName>MySQL</EngineName>
        </DestinationEndpoint>
        <SourceEndpoint>
            <UserName>dtstest</UserName>
            <InstanceID>rm-bp1162kryivb8****</InstanceID>
            <SslSolutionEnum>DISABLE</SslSolutionEnum>
            <Port>3306</Port>
            <Region>cn-hangzhou</Region>
            <InstanceType>RDS</InstanceType>
            <EngineName>MySQL</EngineName>
        </SourceEndpoint>
        <TagList>
            <TagKey>testkey</TagKey>
            <TagValue>testvalue</TagValue>
        </TagList>
        <Performance/>
        <Reserved>{"srcHostPorts":"","whitelist.dms.online.ddl.enable":false,"filterDDL":false,"sqlparser.dms.original.ddl":true,"srcOracleType":"sid","maxRetryTime":43200,"destSSL":"0","destOracleType":"sid","srcSSL":"0","dbListCaseChangeMode":"default","SourceEngineVersion":"8.0.18","srcNetType":"VPC","destNetType":"VPC","srcVpcNetMappingInst":"172.16.1**.**:10803","destVpcNetMappingInst":"172.16.1**.**:11077","useJobTask":"1"}</Reserved>
        <StructureInitializationStatus>
            <Status>Finished</Status>
            <Progress>1</Progress>
            <Percent>100</Percent>
        </StructureInitializationStatus>
        <DataSynchronizationStatus>
            <Status>Catched</Status>
            <Progress>0/0</Progress>
            <Percent>95</Percent>
        </DataSynchronizationStatus>
    </DtsJobList>
    <RequestId>621BB4F8-3016-4FAA-8D5A-5D3163CC****</RequestId>
    <PageNumber>2</PageNumber>
    <HttpStatusCode>200</HttpStatusCode>
    <Success>true</Success>
</DescribeDtsJobsResponse>

JSON format

HTTP/1.1 200 OK
Content-Type:application/json

{
  "TotalRecordCount" : 15,
  "PageRecordCount" : 1,
  "DtsJobList" : [ {
    "Status" : "Migrating",
    "DataInitializationStatus" : {
      "Status" : "Finished",
      "Progress" : "44755",
      "Percent" : "100"
    },
    "DbObject" : "{\"DTSTEST\":{\"name\":\"dtstest\",\"all\":true,\"state\":\"normal\",\"edit\":false}}",
    "CreateTime" : "2021-03-16T08:01:19Z",
    "DtsJobName": "RDS_TO_RDS_MIGRATION",
    "ReverseJob" : {
      "PrecheckStatus" : { },
      "DataInitializationStatus" : { },
      "DestinationEndpoint" : { },
      "SourceEndpoint" : { },
      "Performance" : { },
      "MigrationMode" : { },
      "StructureInitializationStatus" : { },
      "DataSynchronizationStatus" : { }
    },
    "PayType" : "PrePaid",
    "DtsInstanceID" : "dtsi03e3zty16i****",
    "Delay" : 0,
    "MigrationMode" : {
      "DataInitialization" : true,
      "DataSynchronization" : true,
      "StructureInitialization" : true
    },
    "PrecheckStatus" : {
      "Status" : "Finished",
      "Percent" : "100",
      "Detail" : [ {
        "CheckItem" : "CHECK_CONN_SRC",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_CONN_SRC_DETAIL"
      }, {
        "CheckItem" : "CHECK_CONN_DEST",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_CONN_DEST_DETAIL"
      }, {
        "CheckItem" : "CHECK_AUTH_SRC",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_AUTH_SRC_DETAIL"
      }, {
        "CheckItem" : "CHECK_AUTH_DEST",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_AUTH_DEST_DETAIL"
      }, {
        "CheckItem" : "CHECK_BINLOG_ON",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_BINLOG_ON_DETAIL"
      }, {
        "CheckItem" : "CHECK_BINLOG_MODE",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_BINLOG_MODE_DETAIL"
      }, {
        "CheckItem" : "CHECK_BINLOG_ROW_IMAGE",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_BINLOG_ROW_IMAGE_DETAIL"
      }, {
        "CheckItem" : "CHECK_SERVER_ID",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_SERVER_ID_DETAIL"
      }, {
        "CheckItem" : "CHECK_BINLOG_EXIST",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_BINLOG_EXIST_DETAIL"
      }, {
        "CheckItem" : "CHECK_ENGINE",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_ENGINE_DETAIL"
      }, {
        "CheckItem" : "CHECK_MYSQL_PASSOWRD_FORMAT",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_MYSQL_PASSOWRD_FORMAT_DETAIL"
      }, {
        "CheckItem" : "CHECK_SRC",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_SRC_DETAIL"
      }, {
        "CheckItem" : "CHECK_SAME_OBJ",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_SAME_OBJ_DETAIL"
      }, {
        "CheckItem" : "CHECK_SQL_MODE",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_SQL_MODE_DETAIL"
      }, {
        "CheckItem" : "CHECK_SAME_USER",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_SAME_USER_DETAIL"
      }, {
        "CheckItem" : "CHECK_TOPOLOGY",
        "CheckResult" : "Success",
        "CheckItemDescription" : "CHECK_TOPOLOGY_DETAIL"
      } ]
    },
    "DtsJobClass" : "large",
    "Checkpoint" : "1616902385",
    "DtsJobId" : "i03e3zty16i****",
    "DestinationEndpoint" : {
      "UserName" : "dtstest",
      "InstanceID" : "rm-bp1imrtn6fq7h****",
      "SslSolutionEnum" : "DISABLE",
      "Port" : "3306",
      "DatabaseName" : "",
      "Region" : "cn-hangzhou",
      "InstanceType" : "RDS",
      "EngineName" : "MySQL"
    },
    "SourceEndpoint" : {
      "UserName" : "dtstest",
      "InstanceID" : "rm-bp1162kryivb8****",
      "SslSolutionEnum" : "DISABLE",
      "Port" : "3306",
      "Region" : "cn-hangzhou",
      "InstanceType" : "RDS",
      "EngineName" : "MySQL"
    },
    "TagList" : [ {
      "TagKey" : "testkey",
      "TagValue" : "testvalue"
    } ],
    "Performance" : { },
    "Reserved" : "{\"srcHostPorts\":\"\",\"whitelist.dms.online.ddl.enable\":false,\"filterDDL\":false,\"sqlparser.dms.original.ddl\":true,\"srcOracleType\":\"sid\",\"maxRetryTime\":43200,\"destSSL\":\"0\",\"destOracleType\":\"sid\",\"srcSSL\":\"0\",\"dbListCaseChangeMode\":\"default\",\"SourceEngineVersion\":\"8.0.18\",\"srcNetType\":\"VPC\",\"destNetType\":\"VPC\",\"srcVpcNetMappingInst\":\"172.16.1**.**:10803\",\"destVpcNetMappingInst\":\"172.16.1**.**:11077\",\"useJobTask\":\"1\"}",
    "StructureInitializationStatus" : {
      "Status" : "Finished",
      "Progress" : "1",
      "Percent" : "100"
    },
    "DataSynchronizationStatus" : {
      "Status" : "Catched",
      "Progress" : "0/0",
      "Percent" : "95"
    }
  } ],
  "RequestId" : "621BB4F8-3016-4FAA-8D5A-5D3163CC****",
  "PageNumber" : 2,
  "HttpStatusCode" : 200,
  "Success" : true
}

Error codes

For a list of error codes, visit the API Error Center.