The vdsTask table contains data for tasks that where scheduled to run at specific times.
Columns
Table: vdsTask table columns | Column name | Data type | Primary key | Nullable | Description |
|---|
| vdsTaskId | varchar(60) | Yes | No | Unique task ID string. |
| vdsType | varchar(255) | No | No | Defines the type of task. |
| vdsDescription | varchar(255) | No | No | Description of the task, for example, report name, etc. |
| vdsDomain | varchar(255) | No | No | Domain of the user who created the task. |
| vdsUserId | varchar(255) | No | No | User name of the user who created the task. |
| vdsServerId | varchar(64) | No | No | IP address of the server that has the task assigned. The field can contain an empty string which means any server. |
| vdsFeatures | integer | No | No | Bit field describing the features of this task. If features are enabled, they can be modified using generic task commands. |
| vdsFlags | integer | No | No | Scheduling flags. |
| vdsMode | integer | No | No | Defines which server(s) should execute this task. |
| vdsStatus | integer | No | No | The processing status, describing the state of the task. Used for status reporting and notification. |
| vdsStatusContext | varchar(4096) | No | Yes | Serialized task status, like items processed, failed, and other data. The data is task specific. |
| vdsStatusMessage | varchar(1024) | No | Yes | Free text status message used to report the status during execution and results for finished tasks. |
| vdsProgress | integer | No | Yes | Progress of the task in the range of 0–10000. NULL if not started. |
| vdsStartTime | timestamp | No | Yes | The time stamp is set by the first server that starts a task. If another server takes over the task, it will not change the time stamp. |
| vdsEndTime | timestamp | No | Yes | The time stamp is regularily updated by the server that processes the task to reflect an active state (keep alive notification). If the time stamp is too old, it can be assumed that the task is not processed anymore. When a task is finished, it should be set to the finished time. |
| vdsContext | varchar(4096) | No | No | Serialized command attribute set. |
| vdsSchedule | integer | No | Yes | Defines, if this task is scheduled. Requires the Schedule feature to be enabled. |
| vdsScheduleTime | varchar(16) | No | Yes | The task will be executed at the specified time in the server time zone. Valid if vdsSchedule is Scheduled. |
| vdsScheduleDate | varchar(16) | No | Yes | Date to execute the task. Valid if vdsSchedule is Scheduled and vdsRecurrence is None. |
| vdsNotify | varchar(16) | No | Yes | Send a notification message when the task is finished. |
| vdsRecurrence | integer | No | Yes | Defines the recurrence of the task. |
| vdsRecurrenceWeekdays | integer | No | Yes | Bit field defining on which days of the week to execute the scheduled task if vdsSchedule is Scheduled and vdsRecurrence is Daily. |
| vdsRecurrenceMonths | integer | No | Yes | Bit field defining the months in which to execute the scheduled task if vdsSchedule is Scheduled and vdsRecurrence is Monthly. |
| vdsRecurrenceMonthDay | integer | No | Yes | Defines the day of the month on which the task is scheduled if vdsSchedule is Scheduled and vdsRecurrence is Monthly. |
| vdsCreateTime | timestamp | No | No | The date and time the data record was created. |
| vdsModifyTime | timestamp | No | No | The date and time the data record was last modified. |
| vdsVersion | integer | No | Yes | The current data schema version of the data record. |
Keys
Primary key: (vdsTaskId)
Foreign keys: (vdsDomain, vdsUserId) references vdsUser (vdsDomain, vdsUserId)
Indexes
Table: vdsTask table indexes | Index name | Included fields |
|---|
| Level 0 (default) |
| vdstaskidx | vdsTaskId |