HttpQueueActivity

Returns a list of current and recent Http requests queued with the SQLHTTP Agent

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

Remarks:

This view is related to functionality provided by the SQLHTTP Agent Windows Service