show task

Shows the task information for a DA agent.

Syntax

show task

Examples

Example 1 – shows all the tasks for the 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 

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