TaskSchedule Table

This table stores the required information about the task schedule, such as the start and finish times number of retries, delays and other related information.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for TaskSchedule table

Database Column

Details

TaskScheduleID

Type: integer. Key. Generated ID

The id for the task schedule.

StartTime

Type: datetime. Nullable

The time that the scheduled task must start.

EndTime

Type: datetime. Nullable

The time that the scheduled task must end.

RetryCount

Type: integer. Nullable

Number of times for task retries.

MinRetryDelay

Type: integer. Nullable

Number of seconds before a retry occurs in case of a failure.

RepeatDelay

Type: integer. Nullable

Number of seconds before the task is repeated.

NumParallelTasks

Type: integer. Nullable

Number of tasks that can be run in parallel.

SleepBetweenTasks

Type: integer. Nullable

Amount of time before the next task can start.