Task Table

This table stores the information about the tasks.

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 Task table

Database Column

Details

TaskID

Type: integer. Key. Generated ID

The id of the task.

TaskUID

Type: binary (max 16 bytes). Key. Nullable

The id of the task.

TaskTypeID

Type: integer

The id for the task type.

TaskName

Type: text (max 128 characters). Key

The name for the task.

PackagePathID

Type: integer. Key. Nullable

For a distribution task, which package.

TaskScheduleID

Type: integer

The id for the task schedule.

MinimumVersion

Type: text (max 16 characters). Nullable

The minimum version required to execute the task.