Summary of the "lyrTaskScheduler" columns in ListManager

 

This table stores the current jobs scheduled to be run.

 

Primary key: ScheduleID

 

Field Name

Description

Version Added

LastFinishTime

The time at which the last instance of the task finished.

 

LastRunTime

When was this task last run? (datetime, NULL)

 

RunTime

When should this task be run? (datetime, NULL)

 

ScheduleID

A unique, auto-incrementing identifier for this row. (int, NOT NULL)

 

TaskID

What task should be run, from the lyrTaskDescription table. (int, NOT NULL)

 

TaskData

Any integer data needed by the task, such as a mailing ID. (int, NULL)