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