Jobs - Create Or Update

Service:

SQL Database

API Version:

2021-11-01

Membuat atau memperbarui pekerjaan.

PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/jobAgents/{jobAgentName}/jobs/{jobName}?api-version=2021-11-01

Parameter URI

Nama	Dalam	Diperlukan	Jenis	Deskripsi
jobAgentName	path	True	string	Nama agen pekerjaan.
jobName	path	True	string	Nama pekerjaan yang akan didapatkan.
resourceGroupName	path	True	string	Nama grup sumber daya yang berisi sumber daya. Anda dapat memperoleh nilai ini dari Azure Resource Manager API atau portal.
serverName	path	True	string	Nama server.
subscriptionId	path	True	string	ID langganan yang mengidentifikasi langganan Azure.
api-version	query	True	string	Versi API yang digunakan untuk permintaan.

Isi Permintaan

Nama	Jenis	Deskripsi
properties.description	string	Deskripsi pekerjaan yang ditentukan pengguna.
properties.schedule	JobSchedule	Menjadwalkan properti pekerjaan.

Respons

Nama	Jenis	Deskripsi
200 OK	Job	Berhasil memperbarui pekerjaan.
201 Created	Job	Berhasil membuat pekerjaan.
Other Status Codes		Respons Kesalahan: *** 400 ElasticJobsOperationFailed - Operasi manajemen pekerjaan elastis gagal. 400 ElasticJobsOperationFailed - Operasi manajemen pekerjaan elastis gagal. 400 InvalidResourceRequestBody - Properti sumber daya atau sumber daya dalam isi permintaan kosong atau tidak valid. 400 InvalidDuration - Durasi tidak valid. 404 JobAgentNotFound - Agen pekerjaan yang ditentukan tidak ada di server logis yang ditentukan. 404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan 404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan.

Contoh

Create a job with all properties specified

Create a job with default properties

Create a job with all properties specified

Sample Request

HTTP

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/jobs/job1?api-version=2021-11-01

{
  "properties": {
    "description": "my favourite job",
    "schedule": {
      "startTime": "2015-09-24T18:30:01Z",
      "endTime": "2015-09-24T23:59:59Z",
      "type": "Recurring",
      "interval": "PT5M",
      "enabled": true
    }
  }
}

Java

import com.azure.core.util.Context;
import com.azure.resourcemanager.sql.fluent.models.JobInner;
import com.azure.resourcemanager.sql.models.JobSchedule;
import com.azure.resourcemanager.sql.models.JobScheduleType;
import java.time.OffsetDateTime;

/** Samples for Jobs CreateOrUpdate. */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/CreateOrUpdateJobMax.json
     */
    /**
     * Sample code: Create a job with all properties specified.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void createAJobWithAllPropertiesSpecified(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getJobs().createOrUpdateWithResponse("group1", "server1", "agent1",
            "job1",
            new JobInner().withDescription("my favourite job")
                .withSchedule(new JobSchedule().withStartTime(OffsetDateTime.parse("2015-09-24T18:30:01Z"))
                    .withEndTime(OffsetDateTime.parse("2015-09-24T23:59:59Z")).withType(JobScheduleType.RECURRING)
                    .withEnabled(true).withInterval("PT5M")),
            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

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/jobs/job1",
  "name": "job1",
  "type": "Microsoft.Sql/servers/jobAccounts/jobs",
  "properties": {
    "description": "my favourite job",
    "version": 0,
    "schedule": {
      "startTime": "2015-09-24T18:30:01Z",
      "endTime": "2015-09-24T23:59:59Z",
      "type": "Recurring",
      "interval": "PT5M",
      "enabled": true
    }
  }
}

Status code:

201

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/jobs/job1",
  "name": "job1",
  "type": "Microsoft.Sql/servers/jobAccounts/jobs",
  "properties": {
    "description": "my favourite job",
    "version": 0,
    "schedule": {
      "startTime": "2015-09-24T18:30:01Z",
      "endTime": "2015-09-24T23:59:59Z",
      "type": "Recurring",
      "interval": "PT5M",
      "enabled": true
    }
  }
}

Create a job with default properties

Sample Request

HTTP

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/jobs/job1?api-version=2021-11-01

{}

Java

import com.azure.core.util.Context;
import com.azure.resourcemanager.sql.fluent.models.JobInner;

/** Samples for Jobs CreateOrUpdate. */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/CreateOrUpdateJobMin.json
     */
    /**
     * Sample code: Create a job with default properties.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void createAJobWithDefaultProperties(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getJobs().createOrUpdateWithResponse("group1", "server1", "agent1",
            "job1", new JobInner(), 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

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/jobs/job1",
  "name": "job1",
  "type": "Microsoft.Sql/servers/jobAccounts/jobs",
  "properties": {
    "description": "",
    "version": 0,
    "schedule": {
      "startTime": "0001-01-01T00:00:00Z",
      "endTime": "9999-12-31T11:59:59Z",
      "type": "Once",
      "enabled": false
    }
  }
}

Status code:

201

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/jobAgents/agent1/jobs/job1",
  "name": "job1",
  "type": "Microsoft.Sql/servers/jobAccounts/jobs",
  "properties": {
    "description": "",
    "version": 0,
    "schedule": {
      "startTime": "0001-01-01T00:00:00Z",
      "endTime": "9999-12-31T11:59:59Z",
      "type": "Once",
      "enabled": false
    }
  }
}

Definisi

Nama	Deskripsi
Job	Pekerjaan.
JobSchedule	Properti penjadwalan pekerjaan.
JobScheduleType	Menjadwalkan jenis interval

Job

Pekerjaan.

Nama	Jenis	Deskripsi
id	string	ID Sumber Daya.
name	string	Nama sumber daya.
properties.description	string	Deskripsi pekerjaan yang ditentukan pengguna.
properties.schedule	JobSchedule	Menjadwalkan properti pekerjaan.
properties.version	integer	Nomor versi pekerjaan.
type	string	Jenis sumber daya

JobSchedule

Properti penjadwalan pekerjaan.

Nama	Jenis	Nilai Default	Deskripsi
enabled	boolean		Apakah jadwal diaktifkan atau tidak.
endTime	string	9999-12-31T11:59:59+00:00	Jadwalkan waktu akhir.
interval	string		Nilai interval berulang jadwal, jika ScheduleType berulang. ISO8601 format durasi.
startTime	string	0001-01-01T00:00:00+00:00	Jadwalkan waktu mulai.
type	JobScheduleType	Once	Menjadwalkan jenis interval

JobScheduleType

Menjadwalkan jenis interval

Nama	Jenis	Deskripsi
Once	string
Recurring	string