• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

BatchTask Table (243)

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) ●

BatchTask table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top