dbo.ATT_PAfterMigrationTasks

1  create   procedure ATT_PAfterMigrationTasks (@GenProcID varchar(38) ) as begin declare @MyModule varchar(3) = 'ATT' declare @XUser nvarchar(64
2) = object_name(@@procid) declare @Xdate datetime = getutcdate() declare @AttCasePendingNL QBM_YCursorBuffer SET XACT_ABORT OFF BEGIN TRY  insert into 
3@AttCasePendingNL (UID1) select UID_AttestationCase from AttestationCase where DataLength(ReportContent) < 10 update AttestationCase set ReportContent 
4= null  , XDateUpdated = @Xdate , XUserUpdated = @XUser from AttestationCase ac join @AttCasePendingNL h on h.UID1 = ac.UID_AttestationCase where rtrim
5(ReportContent) = ''   declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.UID_Element,
6 null, @GenProcID from ( select y.UID_AttestationPolicy as UID_Element from AttestationPolicy y where y.UID_AttestationPolicy like '___-%'  and y.XUserUpdated
7 like 'QBM_PBufferT_Process%' and y.XDateUpdated > GETUTCDATE() -1 ) as x exec QBM_PDBQueueInsert_Bulk 'ATT-K-HelperAttestationPolicy', @DBQueueElements_01
8   exec QBM_PJobCreate_HOTemplate_B 'HelperAttestationPolicy', 'UID_AttestationPolicy in (select UID_AttestationPolicy
9									from AttestationPolicy p
10									where p.IsInActive = 0
11									)
12							and DisplayName is null'
13, 'DisplayName', @GenProcID , @AdditionalObjectKeysAffected = default , @checkForExisting = 1  exec QBM_PJobCreate_HOFireEvent 'AttestationPolicy', '1=1'
14 , 'RebuildWhereClause', @GenProcID, @objectKeysAffected = default        exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID
15 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH
16 NOWAIT END CATCH endLabel: return end 
17