The content is currently unavailable in French. You are viewing the default English version.
Résumé de l’article
Avez-vous trouvé ce résumé utile ?
Merci pour vos commentaires
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 - e.g. 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.
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.
