Managed Instance Operations - List By Managed Instance

Referensi

Service:: SQL Database

API Version:: 2021-11-01

Mendapatkan daftar operasi yang dilakukan pada instans terkelola.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/operations?api-version=2021-11-01

Parameter URI

Nama	Dalam	Diperlukan	Jenis	Deskripsi
managedInstanceName	path	True	string	Nama instans terkelola.
resourceGroupName	path	True	string	Nama grup sumber daya yang berisi sumber daya. Anda dapat memperoleh nilai ini dari Azure Resource Manager API atau portal.
subscriptionId	path	True	string	ID langganan yang mengidentifikasi langganan Azure.
api-version	query	True	string	Versi API yang digunakan untuk permintaan.

Respons

Nama	Jenis	Deskripsi
200 OK	ManagedInstanceOperationListResult	Permintaan untuk mendapatkan operasi instans terkelola telah berhasil dijalankan.
Other Status Codes		Respons Kesalahan: *** 404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan 404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan.

Nama

Jenis

Deskripsi

200 OK

ManagedInstanceOperationListResult

Permintaan untuk mendapatkan operasi instans terkelola telah berhasil dijalankan.

Other Status Codes

Respons Kesalahan: ***

404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan
404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan.

Contoh

List the managed instance management operations

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations?api-version=2021-11-01


import com.azure.core.util.Context;

/** Samples for ManagedInstanceOperations ListByManagedInstance. */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/ListManagedInstanceOperations.json
     */
    /**
     * Sample code: List the managed instance management operations.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void
        listTheManagedInstanceManagementOperations(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getManagedInstanceOperations()
            .listByManagedInstance("sqlcrudtest-7398", "sqlcrudtest-4645", Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample Response

Status code:: 200

{
  "value": [
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "UpsertManagedServer",
        "operationFriendlyName": "UPDATE MANAGED SERVER",
        "percentComplete": 100,
        "startTime": "2019-12-06T11:08:44.49Z",
        "state": "Cancelled",
        "isCancellable": false
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/11111111-1111-1111-1111-111111111111",
      "name": "11111111-1111-1111-1111-111111111111",
      "type": "Microsoft.Sql/managedInstances/operations"
    },
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "UpsertManagedServer",
        "operationFriendlyName": "UPDATE MANAGED SERVER",
        "percentComplete": 50,
        "startTime": "2019-12-06T11:08:44.49Z",
        "state": "InProgress",
        "isCancellable": true,
        "operationParameters": {
          "currentParameters": {
            "family": "Gen4",
            "tier": "GeneralPurpose",
            "vCores": 8,
            "storageSizeInGB": 32
          },
          "requestedParameters": {
            "family": "Gen4",
            "tier": "BusinessCritical",
            "vCores": 8,
            "storageSizeInGB": 128
          }
        },
        "operationSteps": {
          "totalSteps": "3",
          "currentStep": 3,
          "stepsList": [
            {
              "order": 1,
              "name": "Request validation",
              "status": "Completed",
              "stepEndTime": "2019-12-06T11:08:45.57Z",
              "stepStartTime": "2019-12-06T11:08:44.49Z",
              "timeElapsed": "0"
            },
            {
              "order": 2,
              "name": "Virtual Cluster resize/creation",
              "status": "Completed",
              "stepEndTime": "2019-12-06T11:22:47.35Z",
              "stepStartTime": "2019-12-06T11:08:46.15Z",
              "timeElapsed": "14"
            },
            {
              "order": 3,
              "name": "New SQL Instance Startup",
              "status": "InProgress",
              "stepEndTime": "2019-12-06T11:24:50.51Z",
              "stepStartTime": "2019-12-06T11:22:47.42Z",
              "timeElapsed": "2"
            }
          ]
        }
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/22222222-2222-2222-2222-222222222222",
      "name": "22222222-2222-2222-2222-222222222222",
      "type": "Microsoft.Sql/managedInstances/operations"
    },
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "UpsertManagedServer",
        "operationFriendlyName": "UPDATE MANAGED SERVER",
        "percentComplete": 100,
        "startTime": "2019-12-06T14:48:34.583Z",
        "state": "Failed",
        "errorCode": 45157,
        "errorDescription": "Server 'sqlcrudtest-4645' is busy with another operation. Please try your operation later.",
        "errorSeverity": 16,
        "isUserError": true,
        "isCancellable": false
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/33333333-3333-3333-3333-333333333333",
      "name": "33333333-3333-3333-3333-333333333333",
      "type": "Microsoft.Sql/managedInstances/operations"
    },
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "MakeAllManagedDatabasesAccessible",
        "operationFriendlyName": "MAKE ALL MANAGED DBS ACCESSIBLE",
        "percentComplete": 100,
        "startTime": "2019-12-04T09:00:08.1Z",
        "state": "Failed",
        "operationSteps": {
          "totalSteps": "1",
          "currentStep": 1,
          "stepsList": [
            {
              "order": 1,
              "name": "Request validation",
              "status": "Failed",
              "stepEndTime": "2019-12-04T09:01:00.57Z",
              "stepStartTime": "2019-12-04T09:00:30.15Z",
              "timeElapsed": "0"
            }
          ]
        }
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/44444444-4444-4444-4444-444444444444",
      "name": "44444444-4444-4444-4444-444444444444",
      "type": "Microsoft.Sql/managedInstances/operations"
    }
  ]
}

Definisi

Nama	Deskripsi
ManagedInstanceOperation	Operasi instans terkelola.
ManagedInstanceOperationListResult	Respons terhadap permintaan operasi instans terkelola daftar
ManagedInstanceOperationParametersPair	Parameter operasi instans terkelola.
ManagedInstanceOperationSteps	Langkah-langkah operasi instans terkelola.
ManagementOperationState	Status operasi.
status
UpsertManagedServerOperationParameters
UpsertManagedServerOperationStepWithEstimatesAndDuration

ManagedInstanceOperation

Operasi instans terkelola.

Nama	Jenis	Deskripsi
id	string	ID Sumber Daya.
name	string	Nama sumber daya.
properties.description	string	Deskripsi operasi.
properties.errorCode	integer	Kode kesalahan operasi.
properties.errorDescription	string	Deskripsi kesalahan operasi.
properties.errorSeverity	integer	Tingkat keparahan kesalahan operasi.
properties.estimatedCompletionTime	string	Perkiraan waktu penyelesaian operasi.
properties.isCancellable	boolean	Apakah operasi dapat dibatalkan.
properties.isUserError	boolean	Apakah kesalahan tersebut adalah kesalahan pengguna atau tidak.
properties.managedInstanceName	string	Nama instans terkelola tempat operasi sedang dilakukan.
properties.operation	string	Nama operasi.
properties.operationFriendlyName	string	Nama operasi yang ramah.
properties.operationParameters	ManagedInstanceOperationParametersPair	Parameter operasi.
properties.operationSteps	ManagedInstanceOperationSteps	Langkah-langkah operasi.
properties.percentComplete	integer	Persentase operasi selesai.
properties.startTime	string	Waktu mulai operasi.
properties.state	ManagementOperationState	Status operasi.
type	string	Jenis sumber daya

ManagedInstanceOperationListResult

Respons terhadap permintaan operasi instans terkelola daftar

Nama	Jenis	Deskripsi
nextLink	string	Tautan untuk mengambil halaman hasil berikutnya.
value	ManagedInstanceOperation[]	Array hasil.

ManagedInstanceOperationParametersPair

Parameter operasi instans terkelola.

Nama	Jenis	Deskripsi
currentParameters	UpsertManagedServerOperationParameters	Parameter saat ini.
requestedParameters	UpsertManagedServerOperationParameters	Parameter yang diminta.

ManagedInstanceOperationSteps

Langkah-langkah operasi instans terkelola.

Nama	Jenis	Deskripsi
currentStep	integer	Jumlah langkah operasi saat ini.
stepsList	UpsertManagedServerOperationStepWithEstimatesAndDuration[]	Daftar langkah-langkah operasi.
totalSteps	string	Jumlah total langkah operasi.

ManagementOperationState

Status operasi.

Nama	Jenis	Deskripsi
CancelInProgress	string
Cancelled	string
Failed	string
InProgress	string
Pending	string
Succeeded	string

status

Nama	Jenis	Deskripsi
Canceled	string
Completed	string
Failed	string
InProgress	string
NotStarted	string
SlowedDown	string

UpsertManagedServerOperationParameters

Nama	Jenis	Deskripsi
family	string
storageSizeInGB	integer
tier	string
vCores	integer

UpsertManagedServerOperationStepWithEstimatesAndDuration

Nama	Jenis	Deskripsi
name	string
order	integer
status	status
stepEndTime	string
stepStartTime	string
timeElapsed	string

Bagikan melalui

Managed Instance Operations - List By Managed Instance

Parameter URI

Respons

Contoh

List the managed instance management operations

Sample Request

Sample Response

Definisi

ManagedInstanceOperation

ManagedInstanceOperationListResult

ManagedInstanceOperationParametersPair

ManagedInstanceOperationSteps

ManagementOperationState

status

UpsertManagedServerOperationParameters

UpsertManagedServerOperationStepWithEstimatesAndDuration

Sumber Daya Tambahan: