Purpose
Tracks which messages were successfully transmitted to their intended recipients.
Definition
CREATE TABLE [dbo].[DiM-MessageHistory](
[MessageGUID] [UNIQUEIDENTIFIER] NOT NULL,
[QueuedOn] [DATETIME2](7) NOT NULL,
[MessageQueueGUID] [UNIQUEIDENTIFIER] NOT NULL,
[Sender] [VARCHAR](500) NULL,
[Recipient] [VARCHAR](500) NULL,
[Subject] [VARCHAR](500) NULL,
[ProcessedOn] [DATETIME2](7) NOT NULL,
[Result] [VARCHAR](500) NOT NULL,
CONSTRAINT [PK_MessageHistory] PRIMARY KEY CLUSTERED
(
[MessageGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Column Definition
As per the DiM-Messages table with the following additions:
Result should be ‘SUCCESS’ or otherwise indicate a success transfer depending on the decoupling service implementation (could be a transmission receipt for example).
ProcessedOn contains the timestamp of when the transfer was successfully processed.
The BodyFormat and BodyContent are not preserved if the message was successfully processed.