Task Scheduled Table Schema (task_scheduled)


List of scheduled tasks to be run by cron.

task_scheduled table columns

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

The component this scheduled task belongs to.

classname VARCHAR 255

The class extending scheduled_task to be called when running this task.

lastruntime BIGINT 19 null
nextruntime BIGINT 19 null
blocking TINYINT 3 0

Block the entire cron when this task is running.

minute VARCHAR 25
hour VARCHAR 25
day VARCHAR 25
month VARCHAR 25
dayofweek VARCHAR 25
faildelay BIGINT 19 null
customised TINYINT 3 0

Used on upgrades to prevent overwriting custom schedules.

disabled BIT 1 0

1 means do not run from cron

Table contained -1 rows

task_scheduled table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tasksche_cla_uix Must be unique Asc classname