HttpQueueActivity
Returns a list of current and recent Http requests queued with the SQLHTTP Agent
- View
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
Column name | Data type | Description |
---|---|---|
HttpQueueID | uniqueidentifier | The @HttpQueueID returned from the HttpRequest stored procedure call |
ParentHttpQueueID | uniqueidentifier | The preceding @HttpQueueID from the HttpRequest stored procedure call for the same @HttpSessionID |
HttpSessionID | uniqueidentifier | The @HttpSessionID used in the HttpRequest stored procedure call |
URL | nvarchar(4000) | The @URL from the HttpRequest stored procedure call |
CreatedDateTime | datetime | The date/time the HttpRequest stored procedure was called |
HttpQueueTimeout | int | The number of milliseconds ser for the @httpQueueTimeout parameter of the HttpRequest stored procedure call |
Response | nvarchar(4000) | The HTTP response received by the SQLHTTP Agent wnen calling the HTTP request |
StatusCode | int | The HTTP Status Code received by the SQLHTTP Agent wnen calling the HTTP request |
StatusDescription | nvarchar(MAX) | The HTTP Status Description received by the SQLHTTP Agent wnen calling the HTTP request |
ErrorMessage | nvarchar(4000) | An error message, if any |
AgentDateTime | datetime | The date/time that the SQLHTTP Agent picked up the HTTP request |
ThreadStartDateTime | datetime | The date/time that the SQLHTTP Agent started the HTTP request |
ThreadEndDateTime | datetime | The date/time that the SQLHTTP Agent finished with the HTTP request |
This view is related to functionality provided by the SQLHTTP Agent Windows Service
- AuthListener
- AuthParam
- AuthParamRemove
- AuthParamsClear
- AuthParamSet
- BasicAuthHeader
- FormDataBuilder
- HttpQueueActivity
- HttpRequest
- HttpSession
- IsUrlValid
- OAuthHeader
- QueryStringBuilder
- RaiseHttpError
- RequestHeaderRemove
- RequestHeaders
- RequestHeaderSet
- RequestPartAdd
- ResponseHeaders
- UrlBuilder
- UrlProperty