Table of Contents

Class SqlServerOutboxProcessingOptions

Namespace
Excalibur.Outbox.SqlServer
Assembly
Excalibur.Outbox.SqlServer.dll

Processing options that control batching, retries, timeouts, and leasing for the SQL Server outbox.

public sealed class SqlServerOutboxProcessingOptions
Inheritance
SqlServerOutboxProcessingOptions
Inherited Members

Properties

CommandTimeoutSeconds

Gets or sets the command timeout in seconds for SQL operations.

[Range(1, 2147483647)]
public int CommandTimeoutSeconds { get; set; }

Property Value

int

The command timeout in seconds. Defaults to 30.

DefaultBatchSize

Gets or sets the default batch size for retrieving messages.

[Range(1, 2147483647)]
public int DefaultBatchSize { get; set; }

Property Value

int

The default batch size. Defaults to 100.

FailureBackoffFloorSeconds

Gets or sets the failure-backoff floor F, in seconds: after MarkFailedAsync records a sub-ceiling failure, the message is not re-claimable by the drain until F has elapsed. This bounds the retry cadence of the plain (no fine-grained backoff) path so it cannot hot-loop the drain, while the message remains eventually re-claimable (at-least-once). F is a DEDICATED backoff floor, decoupled from LeaseTimeoutSeconds (the crash-recovery lease window), and MUST exceed the outbox polling interval (default 5 s) — the default satisfies that for the default polling interval.

[Range(1, 3600)]
public int FailureBackoffFloorSeconds { get; set; }

Property Value

int

The failure-backoff floor in seconds. Defaults to 30 (uniform across the outbox family).

LeaseTimeoutSeconds

Gets or sets the lease timeout in seconds for message processing. When a processor claims messages, they are leased for this duration. If the processor fails to complete within this time, the messages become available for other processors to reclaim.

[Range(10, 3600)]
public int LeaseTimeoutSeconds { get; set; }

Property Value

int

The lease timeout in seconds. Defaults to 120 (2 minutes).

MaxRetryCount

Gets or sets the maximum number of retry attempts for failed messages.

[Range(0, 2147483647)]
public int MaxRetryCount { get; set; }

Property Value

int

The maximum retry count. Defaults to 3.

RetryDelayMinutes

Gets or sets the delay in minutes between retry attempts.

[Range(1, 2147483647)]
public int RetryDelayMinutes { get; set; }

Property Value

int

The retry delay in minutes. Defaults to 5.

UseRowLocking

Gets or sets whether to use row-level locking for concurrent access.

public bool UseRowLocking { get; set; }

Property Value

bool

True to enable row-level locking. Defaults to true.