BatchTask Table (243)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
Batch task request details, corresponding to the message body of a batch request message
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| BatchTask_id | Primary key | PK | |
| BatchTaskDefinition_id | Batch task definition, which is populated from code attributes | FK BatchTaskDefinition | ● |
| description | Description of task (for monitoring and debugging) | String(254) | |
| dbTag | Database tag that this task applies to, to ensure tasks are execute on the correct database only | String(39) | |
| state | 0=Unknown; 1=New; 2=Assigned; 3=Started; 4=Succeeded; 5=Failed | Int | |
| detailsTable | Optional table containing further details that will not fit in the standard request/response fields | TableNumber | ● |
| detailsRecord | Optional record containing further details that will not fit in the standard request/response fields | RecordId | ● |
| request | The batch request, specifying what to do | String(254) | ● |
| response | The response from the batch task processor | String(254) | ● |
| startCount | Number of times this batch task has been started (0 for tasks that have never been executed) | Id | ● |
| lastStarted | When was this job last started | DateTime | ● |
| progressPercent | Task progress, in percent of estimated total | UShort | ● |
| progressDescription | Descriptive text for the current stage | String(254) | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | 'heartbeat' that is updated once a minute by the batch task process | UtcDateTime | |
| updated_associate_id | 'heartbeat' that is updated once a minute by the batch task process | FK associate | |
| updatedCount | 'heartbeat' that is updated once a minute by the batch task process | UShort | |
| FileName | The filename related to the batchtask. | String(260) | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| BatchTask_id | PK | Clustered, Unique |
| state | Int | Index |
| BatchTaskDefinition_id, state | FK, Int | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| BatchTaskDefinition | Batch task definitiopns, populated from the SuperOffice.CRM.BatchProcessing.BatchTask attribute |
Replication Flags
- None
Security Flags
- No access control via user's Role.