Gets a summary of the status of job executions.
GET {{baseUrl}}/jobExecutionsStatus?compartmentId=<string>&id=<string>&managedDatabaseGroupId=<string>&managedDatabaseId=<string>&startTime=<string>&endTime=<string>&name=<string>&sortBy=TIMECREATED&sortOrder=ASC
Gets the number of job executions grouped by status for a job, Managed Database, or Database Group in a specific compartment. Only one of the parameters, jobId, managedDatabaseId, or managedDatabaseGroupId should be provided.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
compartmentId | string | (Required) The OCID of the compartment. | |
id | string | The identifier of the resource. | |
managedDatabaseGroupId | string | The OCID of the Managed Database Group. | |
managedDatabaseId | string | The OCID of the Managed Database. | |
startTime | string | (Required) The start time of the time range to retrieve the status summary of job executions | |
| in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |||
endTime | string | (Required) The end time of the time range to retrieve the status summary of job executions | |
| in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |||
name | string | A filter to return only resources that match the entire name. | |
sortBy | string | The field to sort information by. Only one sortOrder can be used. The default sort order | |
| for ‘TIMECREATED’ is descending and the default sort order for ‘NAME’ is ascending. | |||
| The ‘NAME’ sort order is case-sensitive. | |||
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Accept | string |
RESPONSES
status: OK
{"items":[{"status":"FAILED","count":"\u003cinteger\u003e"},{"status":"IN_PROGRESS","count":"\u003cinteger\u003e"}]}