dbo.QBM_TUAssembly_JobRunparameter

1 create   trigger QBM_TUAssembly_JobRunparameter on JobRunparameter  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(ValueTemplate
3)  or update(Name) or update(IsCrypted) or update(IsHidden) or update(UID_JobParameter) or update(UID_Job) or update(IsPartialCrypted) begin declare @DBQueueElements_01
4 QBM_YDBQueueRaw insert into @DBQueueElements_01 (Object, SubObject, GenProcID) select distinct 'JobGen', dbo.QBM_FGITableName(c.UID_DialogTable) , @GenProcID
5 from inserted i join job j on i.uid_Job = j.uid_job join Jobchain c on j.uid_Jobchain = c.uid_Jobchain join JobEventGen e on e.UID_JobChain = c.UID_JobChain
6 where c.IsDeactivatedByPreProcessor = 0 and j.IsDeactivatedByPreProcessor = 0 and c.NoGenerate = 0 exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset'
7, @DBQueueElements_01  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
8