task_adhoc

0 rows


Description

List of adhoc tasks waiting to run.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
component VARCHAR 255 ''

The component that triggered this adhoc task.

classname VARCHAR 255 ''

The name of the class extending adhoc_task to run when this task is executed.

nextruntime BIGINT 19 null
faildelay BIGINT 19 √ NULL
customdata LONGTEXT 2147483647 √ NULL

Custom data to be passed to the adhoc task. Must be serialisable using json_encode()

userid BIGINT 19 √ NULL
user.id taskadho_use2_fkR
timecreated BIGINT 19 0

Timestamp of adhoc task creation

timestarted BIGINT 19 √ NULL

Time when the task was started

hostname VARCHAR 255 √ NULL

Hostname where the task is running

pid BIGINT 19 √ NULL

PHP process ID that is running the task

attemptsavailable TINYINT 3 √ NULL

The remaining attempts for this task

firststartingtime BIGINT 19 √ NULL

The start time of the first run of the task

identityhash VARCHAR 40 √ NULL

Identity key for adhoc tasks, shared when logical duplicate detection is enabled

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
taskadho_ide_uix Must be unique Asc identityhash
taskadho_nex_ix Performance Asc nextruntime
taskadho_nexcla_ix Performance Asc/Asc nextruntime + classname
taskadho_tim_ix Performance Asc timestarted
taskadho_use_ix Performance Asc userid

Relationships