show agent dts

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:

   SERVER              TASK ID CONNECTION OBJECT      STAGE OBJ PROCESSED PREDICATE SQL PROCESSED
   ------------------- ------- ---------- ----------- ----- ------------- --------- --- ---------
   myserver:4500@soka2 4       conn1      dbo.da1_10m       0             0             1
   myserver:4500@soka2 2       conn2      dbo.da1_10m       0             0             1
   myserver:4500@soka2 6       conn3      dbo.da1_10m       0             0             1
  
  (0 rows affected)
   TASK ID ESTIMATE COUNT QUEUE TAKEN    ESTIMATE SECONDS LEFT
   ------- -------------- ----- -------- ---------------------
   4       10000000       0     10000000 0
   2       10000000       0     10000000 0
   6       10000000       0     10000000 0