BatchProcessExecution Table
BatchProcessExecution
is a table storing the details of batch processes requested and executed.
Database Column |
Details |
---|---|
BatchProcessExecutionID
|
Type: integer. Key. Generated ID A unique identifier for a batch processor. |
GUID
|
Type: unique identifier. Key The GUID identifying a batch process execution. |
BatchProcessTypeID
|
Type: integer. Key The type of this batch process execution. Foreign key to the |
Submitted
|
Type: datetime. Key The date and time at which this batch process execution was submitted. |
OperatorLogin
|
Type: text (max 512 characters). Nullable The login name of the operator requesting the batch process, NULL indicates a system request. |
BeaconID
|
Type: integer. Key. Nullable The ID of the beacon which requested a batch process execution. Foreign key to the |
BatchProcessorHostname
|
Type: text (max 128 characters). Key. Nullable The batch processor responsible for the execution of this batch process. A processor by this name may be in the |
BatchProcessStatusID
|
Type: integer Status of the batch process execution. Foreign key to the |
StartTime
|
Type: datetime. Nullable The date and time the batch process execution was started. |
FinishTime
|
Type: datetime. Key. Nullable The date and time the batch process execution finished. |
Progress
|
Type: integer Percentage indicator of how far through the batch process execution is. |
ReturnCode
|
Type: integer. Nullable The return code of the batch process execution. |
Output
|
Type: text. Nullable Contains any output reported by a batch process execution. |
GroupName
|
Type: text (max 50 characters). Nullable The group name used to partition this batch process. Only relevant for types that require separation by group. |
TenantUID
|
Type: text (max 40 characters). Key. Nullable The tenant UID for this batch process. Only relevant for types that require separation by tenant. |
RawMessage
|
Type: text. Nullable The raw, serialized message. Used for pending messages to reconstruct the queue when the batch processor restarts. |