Sql Pool Operations - List
Gets a list of operations performed on the SQL pool.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/operations?api-version=2021-06-01
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
resource
|
path | True |
string |
The name of the resource group. The name is case insensitive. |
sql
|
path | True |
string |
SQL pool name |
subscription
|
path | True |
string |
The ID of the target subscription. |
workspace
|
path | True |
string |
The name of the workspace. |
api-version
|
query | True |
string |
The API version to use for this operation. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
OK |
|
Other Status Codes |
*** Error Responses: ***
|
Examples
List the Sql Analytics pool management operations
Sample Request
GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Synapse/workspaces/sqlcrudtest-4645/sqlPools/testdb/operations?api-version=2021-06-01
Sample Response
{
"value": [
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Synapse/workspaces/sqlcrudtest-4645/sqlPools/testdb/operations/11111111-1111-1111-1111-111111111111",
"name": "11111111-1111-1111-1111-111111111111",
"type": "Microsoft.Synapse/workspaces/sqlPools/operations",
"properties": {
"databaseName": "testdb",
"operation": "UpdateLogicalDatabase",
"operationFriendlyName": "ALTER DATABASE",
"percentComplete": 100,
"serverName": "sqlcrudtest-4645",
"startTime": "2017-06-01T09:10:08.10Z",
"state": "Succeeded",
"estimatedCompletionTime": "2017-06-01T13:10:10Z",
"description": "UpdateLogicalDatabase on 'testdb', target ServiceLevelObjective S3",
"isCancellable": false
}
},
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Synapse/workspaces/sqlcrudtest-4645/sqlPools/testdb/operations/55555555-5555-5555-5555-555555555555",
"name": "55555555-5555-5555-5555-555555555555",
"type": "Microsoft.Synapse/workspaces/sqlPools/operations",
"properties": {
"databaseName": "testdb",
"operation": "UpdateLogicalDatabase",
"operationFriendlyName": "ALTER DATABASE",
"percentComplete": 19,
"serverName": "sqlcrudtest-4645",
"startTime": "2017-06-01T10:10:08.10Z",
"state": "InProgress",
"estimatedCompletionTime": "2017-06-01T13:10:10Z",
"description": "UpdateLogicalDatabase on 'testdb', target ServiceLevelObjective S3",
"isCancellable": true
}
}
]
}
Definitions
Name | Description |
---|---|
Management |
The operation state. |
Sql |
The response to a list Sql pool operations request |
Sql |
A Sql pool operation. |
ManagementOperationState
The operation state.
Name | Type | Description |
---|---|---|
CancelInProgress |
string |
|
Cancelled |
string |
|
Failed |
string |
|
InProgress |
string |
|
Pending |
string |
|
Succeeded |
string |
SqlPoolBlobAuditingPolicySqlPoolOperationListResult
The response to a list Sql pool operations request
Name | Type | Description |
---|---|---|
nextLink |
string |
Link to retrieve next page of results. |
value |
Array of results. |
SqlPoolOperation
A Sql pool operation.
Name | Type | Description |
---|---|---|
id |
string |
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
name |
string |
The name of the resource |
properties.databaseName |
string |
The name of the Sql pool the operation is being performed on. |
properties.description |
string |
The operation description. |
properties.errorCode |
integer |
The operation error code. |
properties.errorDescription |
string |
The operation error description. |
properties.errorSeverity |
integer |
The operation error severity. |
properties.estimatedCompletionTime |
string |
The estimated completion time of the operation. |
properties.isCancellable |
boolean |
Whether the operation can be cancelled. |
properties.isUserError |
boolean |
Whether or not the error is a user error. |
properties.operation |
string |
The name of operation. |
properties.operationFriendlyName |
string |
The friendly name of operation. |
properties.percentComplete |
integer |
The percentage of the operation completed. |
properties.serverName |
string |
The name of the server. |
properties.startTime |
string |
The operation start time. |
properties.state |
The operation state. |
|
type |
string |
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" |