Managed Instance Operations - List By Managed Instance

Layanan:

SQL Database

Versi API:

2023-08-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=2023-08-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 API Azure Resource Manager atau portal.
subscriptionId	path	True	string	ID langganan yang mengidentifikasi langganan Azure.
api-version	query	True	string	Versi API yang akan digunakan untuk permintaan tersebut.

Respons

Nama	Jenis	Deskripsi
200 OK	ManagedInstanceOperationListResult	Permintaan untuk mendapatkan operasi instans terkelola telah berhasil dijalankan.
Other Status Codes	ErrorResponse	Respons Kesalahan: *** 400 ManagedInstanceStoppingOrStopped - Operasi yang bertentangan dikirimkan saat instans dalam status berhenti/dihentikan 400 ManagedInstanceStarting - Operasi bertentangan yang dikirimkan saat instans dalam status mulai 404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan. 404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan

Contoh

List the managed instance management operations

Permintaan sampel

HTTP

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

Respon sampel

Kode status:

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
ErrorAdditionalInfo	Info tambahan kesalahan manajemen sumber daya.
ErrorDetail	Detail kesalahan.
ErrorResponse	Respons kesalahan
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.
ManagementOperationStepState
UpsertManagedServerOperationParameters
UpsertManagedServerOperationStepWithEstimatesAndDuration

ErrorAdditionalInfo

Objek

Info tambahan kesalahan manajemen sumber daya.

Nama	Jenis	Deskripsi
info	object	Info tambahan.
type	string	Jenis info tambahan.

ErrorDetail

Objek

Detail kesalahan.

Nama	Jenis	Deskripsi
additionalInfo	ErrorAdditionalInfo[]	Info tambahan kesalahan.
code	string	Kode kesalahan.
details	ErrorDetail[]	Detail kesalahan.
message	string	Pesan kesalahan.
target	string	Target kesalahan.

ErrorResponse

Objek

Respons kesalahan

Nama	Jenis	Deskripsi
error	ErrorDetail	Objek kesalahan.

ManagedInstanceOperation

Objek

Operasi instans terkelola.

Nama	Jenis	Deskripsi
id	string	ID Sumber Daya.
name	string	Nama sumber daya.
properties.description	string	Deskripsi operasi.
properties.errorCode	integer (int32)	Kode kesalahan operasi.
properties.errorDescription	string	Deskripsi kesalahan operasi.
properties.errorSeverity	integer (int32)	Tingkat keparahan kesalahan operasi.
properties.estimatedCompletionTime	string (date-time)	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 (int32)	Persentase operasi selesai.
properties.startTime	string (date-time)	Waktu mulai operasi.
properties.state	ManagementOperationState	Status operasi.
type	string	Jenis sumber daya.

ManagedInstanceOperationListResult

Objek

Respons terhadap permintaan operasi instans terkelola daftar

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

ManagedInstanceOperationParametersPair

Objek

Parameter operasi instans terkelola.

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

ManagedInstanceOperationSteps

Objek

Langkah-langkah operasi instans terkelola.

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

ManagementOperationState

Enumerasi

Status operasi.

Nilai	Deskripsi
Pending
InProgress
Succeeded
Failed
CancelInProgress
Cancelled

ManagementOperationStepState

Enumerasi

Nilai	Deskripsi
NotStarted
InProgress
SlowedDown
Completed
Failed
Canceled

UpsertManagedServerOperationParameters

Objek

Nama	Jenis	Deskripsi
family	string
storageSizeInGB	integer (int32)
tier	string
vCores	integer (int32)

UpsertManagedServerOperationStepWithEstimatesAndDuration

Objek

Nama	Jenis	Deskripsi
name	string
order	integer (int32)
status	ManagementOperationStepState
stepEndTime	string (date-time)
stepStartTime	string (date-time)
timeElapsed	string