create procedure [dbo].[XLedgerMarkTransactionHoldStatusChangeAsFailure]
    @submissionIds IntList readonly,
    @exception nvarchar(max)
as
begin
    set nocount on

    declare @now datetimeoffset = sysdatetimeoffset()

    update XLedgerTransactionHoldSubmission set
        CompletedOn = @now,
        FailureMessage = @exception
    from @submissionIds Ids
    where XLedgerTransactionHoldSubmission.XLedgerTransactionHoldSubmissionId = Ids.Item
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerMarkTransactionHoldStatusChangeAsFailure] TO [MssExec]
GO