Queries the log that records the scheduling details of an SQL 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 | GetDBTaskSQLJobLog |
The operation that you want to perform. Set the value to GetDBTaskSQLJobLog. |
JobId | Long | Yes | 1276**** |
The ID of the SQL task. You can call the ListDBTaskSQLJob operation to query the ID of the SQL task. |
Tid | Long | No | 3*** |
The ID of the tenant. You can call the GetUserActiveTenant operation to query the tenant ID. |
RegionId | String | No | cn-hangzhou |
The region in which DMS is activated. For more information, see RegionID parameter. |
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | 4AC23904-55DE-550B-9676-E8946F07**** |
The ID of the request. |
Success | Boolean | true |
Indicates whether the request was successful. Valid values:
|
ErrorMessage | String | JobId is mandatory for this action. |
The error message returned. |
ErrorCode | String | MissingJobId |
The error code returned. |
Log | String | log_**** |
The log that records the scheduling details. |
Examples
Sample requests
http(s)://dms-enterprise.aliyuncs.com/?Action=GetDBTaskSQLJobLog
&JobId=1276****
&Tid=3***
&Common request parameters
Sample success responses
XML
format
HTTP/1.1 200 OK
Content-Type:application/xml
<GetDBTaskSQLJobLogResponse>
<RequestId>4AC23904-55DE-550B-9676-E8946F07****</RequestId>
<Log>
------[2021-12-08 12:05:31]------
The SQL task is created. Group ID: 0. Group order: 0.
------[2021-12-08 12:05:32]------
The SQL task is being initialized.
------[2021-12-08 12:05:32]------
qn_bzbh5@rm-bp144d5ky4l4rli0417****.mysql.rds.****.com:3306[qn_rds mysql]
------[2021-12-08 12:05:32]------
use normal connection :Normal
------[2021-12-08 12:05:32]------
The transaction is closed.
------[2021-12-08 12:05:32]------
The SQL task is started. A total of one SQL statement is to be executed. queryKey: executeKey_12763320_598
------[2021-12-08 12:05:33]------
change done!
------[2021-12-08 12:05:33]------
The SQL task is completed.
------[2021-12-08 12:05:33]------
jobSuccess callback Start.
------[2021-12-08 12:05:33]------
start database level metadata sync task [Master]...
database table level sync. cost:355 ms
------[2021-12-08 12:05:33]------
group success callback end !
------[2021-12-08 12:05:33]------
jobSuccess callback End.
</Log>
<Success>true</Success>
</GetDBTaskSQLJobLogResponse>
JSON
format
HTTP/1.1 200 OK
Content-Type:application/json
{
"RequestId" : "4AC23904-55DE-550B-9676-E8946F07****",
"Log" : "\r\n------[2021-12-08 12:05:31]------\r\n The SQL task is created. Group ID: 0. Group order: 0:0\r\n\r\n------[2021-12-08 12:05:32]------\r\n The SQL task is being initialized.\r\n\r\n------[2021-12-08 12:05:32]------\r\nqn_bzbh5@rm-bp144d5ky4l4rli0417****.mysql.rds.****.com:3306 [qn_rds mysql]\r\n\r\n------[2021-12-08 12:05:32]------\r\nuse normal connection :Normal\r\n\r\n------[2021-12-08 12:05:32]------\r\n The transaction is closed.\r\n\r\n------[2021-12-08 12:05:32]------\r\n The SQL task is started. A total of one SQL statement is to be executed. queryKey: executeKey_12763320_598\r\n\r\n------[2021-12-08 12:05:33]------\r\nchange done! \r\n\r\n------[2021-12-08 12:05:33]------\r\n The SQL task is completed.\r\n\r\n------[2021-12-08 12:05:33]------\r\njobSuccess callback Start.\r\n\r\n------[2021-12-08 12:05:33]------\r\nstart database level metadata sync task [Master]...\r\n\r\ndatabase table level sync. cost:355 ms\r\n------[2021-12-08 12:05:33]------\r\ngroup success callback end ! \r\n\r\n------[2021-12-08 12:05:33]------\r\njobSuccess callback End.\r\n",
"Success" : true
}
Error codes
For a list of error codes, visit the API Error Center.