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

Remarks:

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

See Also: