dbo.QBM_TUAssembly_Job

1 create   trigger QBM_TUAssembly_Job on Job  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(NotifyAddress) or update(NotifyAddressSuccess) or update(NotifyBody) or update(NotifyBodySuccess) or update(NotifySender) or update(NotifySenderSuccess
4) or update(NotifySubject) or update(NotifySubjectSuccess) or update(PreCode) or update(ProcessDisplay) or update(ServerDetectScript) or update(ProcessInfoLevel
5) or update(IsToFreezeOnError) or update(IgnoreErrors) or update(DeferOnError) or update(MinutesToDefer) or update(IsSplitOnly) or update(Name) or update
6(PreProcessorCondition) or update(UID_Job) or update(UID_JobTask) or update(Retries) or update(Priority) or update(PriorityDefinition) or update(UID_SuccessJob
7) or update(UID_ErrorJob) or update(LogMode) or update(ProcessTracking) or update(IsForHistory) or update(IsNoDBQueueDefer)  or update(UID_QBMServerTag
8) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select distinct 'JobGen', dbo.QBM_FGITableName
9(c.UID_DialogTable) , @GenProcID from inserted i join Jobchain c on i.uid_Jobchain = c.uid_Jobchain join JobEventGen e on e.UID_JobChain = c.UID_JobChain
10 where c.IsDeactivatedByPreProcessor = 0 and c.NoGenerate = 0 exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset', @DBQueueElements_01  end if update
11(IsDeactivatedByPreProcessor) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02(Object, SubObject, GenProcID) select distinct
12 'JobGen', dbo.QBM_FGITableName(c.UID_DialogTable) , @GenProcID from inserted i join Jobchain c on i.uid_Jobchain = c.uid_Jobchain join JobEventGen e on
13 e.UID_JobChain = c.UID_JobChain exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset', @DBQueueElements_02 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
14 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
15