Reference Guide > TDV and Business Directory System Tables > SYS_TASKS
 
SYS_TASKS
The SYS_TASKS system table provides a list of all tasks running in the system. Users see no rows unless they have the ACCESS_TOOLS right. Users with this right can see all rows.
Column
TDV JDBC Data Type
Nullable
Description
TASK_ID
BIGINT
 
Task identifier.
TASK_CATEGORY
VARCHAR(60)
No
Task category.
TASK_TYPE
VARCHAR(255)
No
Task type.
NAME
VARCHAR(16777215)
 
Task name.
RESOURCE_IDS
VARCHAR(16777215)
 
Comma-separated list of identifiers of resources involved.
FROM_RESOURCE_IDS
VARCHAR(16777215)
 
Comma-separated list of identifiers of “from” resources involved.
TO_RESOURCE_IDS
VARCHAR(16777215)
 
Comma-separated list of identifiers of “to” resources involved.
PARENT_TASK_ID
BIGINT
 
Parent task identifier.
DEPENDENT_TASK_IDS
VARCHAR(16777215)
 
Dependent task identifiers.
STATUS
VARCHAR(60)
No
The status of the task.
START_TIME
TIMESTAMP
 
Time when the task started.
END_TIME
TIMESTAMP
 
Time when the task ended.
DURATION
BIGINT
 
Total processing time, in milliseconds.
SCAN_ID
INTEGER
 
ID for associated groups of tasks.
PROCESSING_TIME_REMAINING
BIGINT
 
Time remaining to execute this task.
TOTAL_TIME_REMAINING
BIGINT
 
Time remaining to execute a parent task and all of its offspring.
ROWS_PROCESSED
BIGINT
Yes
Number of table rows already processed.
OWNER_ID
INTEGER
 
ID of the user who created the task.
OWNER
VARCHAR(255)
 
Name of the user who created the task.
ERROR_CODE
INTEGER
Yes
Error code if task failed.
ERROR_MESSAGE
VARCHAR(16777215)
Yes
Error message if task failed.
FLAGS
INTEGER
 
For internal use only.
CID
INTEGER
 
For internal use only.
CLEARED
BIT
Yes
Blocks display of this task in user interface.