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:

  • true: The request was successful.
  • false: The request failed.
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.