show task

Shows the task information for a remote agent.

Syntax

show task

Examples

Example 1 – shows all the tasks for the remote DA agent:

show task 
go

The returned result is:

 SERVER                       TASK ID CONNECTION  OBJECT   STAGE 
 -----------------------     ------- ---------  -------- -----  
 OBJ PROCESSED PREDICATE SQL PROCESSED 
 ------------- --------- --------------
 myserver:4500@soka.sybase.com 35      conn1_1t8p  dbo.da1_10m  0   
 myserver:4500@soka.sybase.com 37      conn1_23mw  dbo.da1_10m  0     
 (0 rows affected)

 TASK ID ESTIMATE COUNT QUEUE TAKEN ESTIMATE SECONDS LEFT
 ------- -------------- ----- ----- ---------------------
 35      10000          0     
 37      10000          0