GetScheduledQueryHistory
Retrieves the execution history of a scheduled query within a specified time range, including execution status and destination processing metadata.
Request Syntax
{
"endTime": number,
"executionStatuses": [ "string" ],
"identifier": "string",
"maxResults": number,
"nextToken": "string",
"startTime": number
}
Request Parameters
For information about the parameters that are common to all actions, see Common Parameters.
The request accepts the following data in JSON format.
- endTime
-
The end time for the history retrieval window in Unix epoch time.
Type: Long
Valid Range: Minimum value of 0.
Required: Yes
- executionStatuses
-
Filter results by execution status (Running, Complete, Failed, Timeout, or InvalidQuery).
Type: Array of strings
Valid Values:
Running | InvalidQuery | Complete | Failed | TimeoutRequired: No
- identifier
-
The name or ARN of the scheduled query to retrieve history for.
Type: String
Pattern:
[\w#+=/:,.@-]*Required: Yes
- maxResults
-
The maximum number of history records to return in a single call.
Type: Integer
Valid Range: Minimum value of 1. Maximum value of 1000.
Required: No
- nextToken
-
The token for the next set of items to return. The token expires after 24 hours.
Type: String
Length Constraints: Minimum length of 1.
Required: No
- startTime
-
The start time for the history retrieval window in Unix epoch time.
Type: Long
Valid Range: Minimum value of 0.
Required: Yes
Response Syntax
{
"name": "string",
"nextToken": "string",
"scheduledQueryArn": "string",
"triggerHistory": [
{
"destinations": [
{
"destinationIdentifier": "string",
"destinationType": "string",
"errorMessage": "string",
"processedIdentifier": "string",
"status": "string"
}
],
"errorMessage": "string",
"executionStatus": "string",
"queryId": "string",
"triggeredTimestamp": number
}
]
}
Response Elements
If the action is successful, the service sends back an HTTP 200 response.
The following data is returned in JSON format by the service.
- name
-
The name of the scheduled query.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern:
^[a-zA-Z0-9_\-/.#]+$ - nextToken
-
The token for the next set of items to return. The token expires after 24 hours.
Type: String
Length Constraints: Minimum length of 1.
- scheduledQueryArn
-
The ARN of the scheduled query.
Type: String
- triggerHistory
-
The list of execution history records for the scheduled query.
Type: Array of TriggerHistoryRecord objects
Errors
For information about the errors that are common to all actions, see Common Errors.
- AccessDeniedException
-
You don't have sufficient permissions to perform this action.
HTTP Status Code: 400
- InternalServerException
-
An internal server error occurred while processing the request. This is typically a temporary issue and the request can be retried.
HTTP Status Code: 500
- ResourceNotFoundException
-
The specified resource does not exist.
HTTP Status Code: 400
- ThrottlingException
-
The request was throttled because of quota limits.
HTTP Status Code: 400
- ValidationException
-
One of the parameters for the request is not valid.
HTTP Status Code: 400
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following: