BatchTaskDefinition Table (244)

• 2 minutes to read
 • 2 minutes to read

Batch task definitiopns, populated from the SuperOffice.CRM.BatchProcessing.BatchTask attribute

Fields

Name Description Type Null
BatchTaskDefinition_id Primary key PK
name Name of task (for monitoring and debugging) String(254)
description Description of task (for monitoring and debugging) String(254)
isMultiPass Is this a multipass job (inner implementationis run repeatedly by the batch task framework) Bool
startInterval Minimum interval between successive starts; starts never overlap Int
minimumSleepTime Minimum sleep interval between the end of one run and start of the next one Int
timeout Maximum allowed execution time; jobs are killed if they exceed their timeout; 0=no timeout Int
autoRestartCount Number of times the whole batch task should be restarted; -1 means infinite, which is useful for things like Travel Gateway that should 'always' be available Int
assemblyVersion Version of the assembly that contains the code this batch task definition was populated from String(49)
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

BatchTaskDefinition table relationship diagram

Indexes

Fields Types Description
BatchTaskDefinition_id PK Clustered, Unique
name String(254) Index
name, assemblyVersion String(254), String(49) Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
BatchTask Batch task request details, corresponding to the message body of a batch request message

Replication Flags

  • None

Security Flags

  • No access control via user's Role.