Creates a job.
POST {{baseUrl}}/jobs
Creates a job to be executed on a Managed Database or Managed Database Group. Only one of the parameters, managedDatabaseId or managedDatabaseGroupId should be provided as input in CreateJobDetails resource in request body.
Request Body
{"name"=>"<string>", "compartmentId"=>"<string>", "jobType"=>"SQL", "scheduleType"=>"<string>", "databaseSubType"=>"CDB", "description"=>"<string>", "managedDatabaseGroupId"=>"<string>", "managedDatabaseId"=>"<string>", "resultLocation"=>{"type"=>"OBJECT_STORAGE"}, "scheduleDetails"=>{"endTime"=>"<string>", "intervalType"=>"NEVER", "intervalValue"=>"<string>", "startTime"=>"<string>"}, "timeout"=>"<string>"}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | A token that uniquely identifies a request so it can be retried in case of a timeout or | |
server error without risk of executing that same action again. Retry tokens expire after 24 | |||
hours, but can be invalidated before then due to conflicting operations. For example, if a resource | |||
has been deleted and purged from the system, then a retry of the original creation request | |||
might be rejected. | |||
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"id":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e","name":"\u003cstring\u003e","scheduleType":"LATER","jobType":"SQL","lifecycleState":"ACTIVE","timeCreated":"\u003cdateTime\u003e","timeUpdated":"\u003cdateTime\u003e","databaseSubType":"ADB","description":"\u003cstring\u003e","managedDatabaseGroupId":"\u003cstring\u003e","managedDatabaseId":"\u003cstring\u003e","managedDatabasesDetails":[{"name":"\u003cstring\u003e","id":"\u003cstring\u003e","databaseSubType":"ACD","databaseType":"CLOUD_RAC","deploymentType":"EXADATA_CC","isCluster":"\u003cboolean\u003e","workloadType":"OLTP"},{"name":"\u003cstring\u003e","id":"\u003cstring\u003e","databaseSubType":"PDB","databaseType":"CLOUD_RAC","deploymentType":"VM","isCluster":"\u003cboolean\u003e","workloadType":"APEX"}],"resultLocation":{"type":"OBJECT_STORAGE"},"scheduleDetails":{"endTime":"\u003cstring\u003e","intervalType":"NEVER","intervalValue":"\u003cstring\u003e","startTime":"\u003cstring\u003e"},"submissionErrorMessage":"\u003cstring\u003e","timeout":"\u003cstring\u003e"}