TaskExecutionStatus Table

The TaskExecutionStatus table stores progress data for rules and background 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 `TaskExecutionStatus` table
Database Column	Details
`TaskExecutionStatusID`	Type: integer. Key. Generated ID Auto-generated task execution status ID
`SessionUID`	Type: unique identifier. Key Unique task run identifier
`TaskName`	Type: text (max 255 characters). Key The name of task.
`ActivityTypeID`	Type: integer. Key Foreign key to the `ActivityType` table
`DateStarted`	Type: datetime. Nullable Start date and time for a task. Date values in the `TaskExecutionStatus` table are stored as UTC. The UI converts these dates to the user’s selected timezone from the MyPreferences page. Log file dates are written in the server’s local timezone without conversion, as they are used only for debugging.
`DateCompleted`	Type: datetime. Nullable Completion date and time for a task. Date values in the `TaskExecutionStatus` table are stored as UTC. The UI converts these dates to the user’s selected timezone from the MyPreferences page. Log file dates are written in the server’s local timezone without conversion, as they are used only for debugging.
`EventTypeStatusID`	Type: integer. Key Foreign key to the `EventTypeStatus` table
`BeaconRuleID`	Type: integer. Key. Nullable Foreign key to the `BeaconRule` table
`ScheduledTriggerDateTick`	Type: big integer. Key. Nullable Executed date time in Tick.
`BeaconID`	Type: integer. Key. Nullable Beacon where the task is executing.
`BeaconPolicyRevision Number`	Type: integer. Nullable Beacon policy revision number
`OperatorLogin`	Type: text (max 255 characters). Nullable Login of the operator who started task.