Task Log Table Schema (task_log)


The log table for all tasks

task_log table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
type SMALLINT 5 null

The type of task. Scheduled task = 0; Adhoc task = 1.

component VARCHAR 255

The component that the task belongs to

classname VARCHAR 255

The class of the task being run

userid BIGINT 19 null
user.id Implied Constraint R

The userid that the task was configured to run as (Adhoc tasks only)

timestart DECIMAL 20,10 null

The start time of the task

timeend DECIMAL 20,10 null

The end time of the task

dbreads BIGINT 19 null

The number of DB reads performed during the task.

dbwrites BIGINT 19 null

The number of DB writes performed during the task.

result TINYINT 3 null

Whether the task was successful or not. 0 = pass; 1 = fail.

output LONGTEXT 2147483647 null

Table contained -1 rows

task_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tasklog_cla_ix Performance Asc classname
tasklog_tim_ix Performance Asc timestart

task_log table relationships