[dbo].[XLedgerMarkConfigSyncAsFailure]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.XLedgerMarkConfigSyncAsFailure

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@syncHistoryIds	IntList	max
@failureMessage	varchar(max)	max

Type	Action	Owning Principal
Grant	Execute	MssExec

CREATE PROCEDURE [dbo].[XLedgerMarkConfigSyncAsFailure]
    @syncHistoryIds IntList readonly,
    @failureMessage varchar(max)
AS
begin
    set nocount on

    declare @now datetimeoffset = sysdatetimeoffset()

    update XLedgerOnDemandSyncHistory set
        FailureMessage = @failureMessage
    from @syncHistoryIds Ids
    inner join XLedgerOnDemandSyncHistory on Ids.Item = XLedgerOnDemandSyncHistory.XLedgerOnDemandSyncHistoryId
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerMarkConfigSyncAsFailure] TO [MssExec]
GO