Interviewer - Server > Reference > Email component > SQL scheduling tables > Schedule table
 
Schedule table
The Schedule table defines the task schedule.
Columns
Id
Datatype: int
Allow Nulls: no
Unique identifier for the table row.
TimeZone
Datatype: int
Allow Nulls: no
The time zone for this schedule. The value is used by the user interface to convert UTC times to the appropriate display times.
StartTime
Datatype: datetime
Allow Nulls: no
The time to start the task (UTC). A task can be submitted for a later start time. The NextDueTime in the ScheduleTask table should be set to the StartTime when a task is submitted.
EndTime
Datatype: datetime
Allow Nulls: yes
Sets the task to Complete at this time (UTC). When the value is Null, the task runs until the project is deleted.
RecurrenceInterval
Datatype: int
Allow Nulls: no
The interval, in minutes, between batches of the same task. If 0, send only once then mark as completed.
See also
SQL scheduling tables