Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Cloud DBA/ Querying SQL Statement Concurrency Control Tasks
Updated on 2024-08-05 GMT+08:00
View PDF
Share

Querying SQL Statement Concurrency Control Tasks

Function

This API is used to query information about an SQL concurrency control task with a specified ID.

URI

GET /v3/{project_id}/instances/{instance_id}/sql-limit/job

Table 1 Path parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID.

To obtain this value, see Obtaining a Project ID.

instance_id

Yes

String

Instance ID.
Table 2 Query parameters

Parameter

Mandatory

Type

Description

job_id

Yes

String

ID of a SQL statement concurrency control task.

Request Parameters

Table 3 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token.

X-Language

No

String

Language.

The value can be:

  • zh-cn
  • en-us

Response Parameters

Status code: 200

Table 4 Response body parameters

Parameter

Type

Description

job_id

String

Task ID.

job_status

String

Task status.

The value can be:

  • RUNNING
  • COMPLETED
  • FAILED

fail_reason

String

Failure cause.

Status code: 400

Table 5 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

Minimum length: 8

Maximum length: 36

error_msg

String

Error message.

Minimum length: 2

Maximum length: 512

Status code: 500

Table 6 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

Minimum length: 8

Maximum length: 36

error_msg

String

Error message.

Minimum length: 2

Maximum length: 512

Example Requests

Querying SQL statement concurrency control tasks

GET https://das.cn-north-1.myhuaweicloud.com/v3/054c630ff780d4cc2f40c00d7f6fb21d/instances/6243b3fcf2f948578d46ed4c52fb54eein01/sql-limit/job?job_id=15535

Example Responses

Status code: 200

Success

{
  "job_id" : "15535",
  "job_status" : "COMPLETED",
  "fail_reason" : ""
}

Status Code

Status Code

Description

200

Success.

400

Client error.

500

Server error.

Error Code

For details, see Error Codes.

Parent topic: Cloud DBA