show agent dts

Shows the data transfer stream (DTS) information that is running on a specified agent.

Syntax

show agent dts agent_name

Parameters

agent_name – the name of the agent.

Examples

Example 1 – shows all the DTS information for “agent1”:

show agent dts agent1
go

The returned result is:

       
TASK ID    ESTIMATE COUNT FETCHING QUEUE TAKEN ESTIMATE SECONDS LEFT
---------- -------------- -------- ----- ----- ---------------------
4          511            true     0     511   0