This table store all the current tasks maintained by the task manager in USD. A typical task can be a job that was setup using a user interface, another task could be a task that handles distributions from the enterprise manager to the domain manager.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectid | byte(16) | not null | Primary key, it is a uuid. |
| version | integer | not null | Version number is used to maintain cache and an optimistic transaction policy |
| referredentity | byte(16) | not null | This column refers to different objects depending on the task type, cannot be FK. |
| tasktype | integer | not null | This is the task type, typically Rec (Receive) or Dist (Distribute) etc. |
| taskstate | integer | not null | Depending on task type, stores the state of the task. |
| creationtime | integer | not null | Creation time of the task. |
| activationtime | integer | not null | Activation time of the task. |
| transactiontime | integer | not null | Transaction time of the task. |
| runningstate | integer | not null | Task running true/false |
| runcounter | integer | not null | Number of times a task has been running |
| lasteventmsgtime | integer | not null | Stores when lastEventMsgId is set. |
| noofmsgparameters | integer | not null | Number of parameters in eventMsgParams |
| lasteventmsgid | integer | not null | The id of the last known event that ocurred in the task. |
| eventmsgparams | nvarchar(1023) | not null | The parameters that is used together with the lastEventMsgId to create a text displayed to the user. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table