dbo.QBM_TUAssembly_JobChain

1 create   trigger QBM_TUAssembly_JobChain on JobChain  for Update not for Replication as begin  declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: if update(GenCondition
3) or update(PreCode) or update(ProcessDisplay) or update(Name) or update(UID_Job) or update(LimitationCount) or update(LimitationWarning) or update(PreProcessorCondition
4) or update(NoGenerate) or update(UID_DialogTable) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject,
5 GenProcID) select 'JobGen', dbo.QBM_FGITableName(i.UID_DialogTable) , @GenProcID from inserted i join JobEventGen e on i.UID_JobChain = e.UID_JobChain
6 where i.IsDeactivatedByPreProcessor = 0 and i.NoGenerate = 0 union select 'JobGen', dbo.QBM_FGITableName(i.UID_DialogTable) , @GenProcID from deleted 
7i join JobChain c on i.UID_JobChain = c.UID_JobChain join JobEventGen e on i.UID_JobChain = e.UID_JobChain where i.IsDeactivatedByPreProcessor = 0 and 
8(i.NoGenerate = 0 or c.NoGenerate = 0 ) exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset', @DBQueueElements_01  end if update(IsDeactivatedByPreProcessor
9) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02(Object, SubObject, GenProcID) select 'JobGen', dbo.QBM_FGITableName
10(i.UID_DialogTable) , @GenProcID from inserted i join JobEventGen e on i.UID_JobChain = e.UID_JobChain exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset'
11, @DBQueueElements_02 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
12