dbo.DPR_TUDialogTable

1  create   trigger DPR_TUDialogTable on DialogTable  for Update not for Replication as begin declare @Starten datetime = dateadd(ss, 100, getutcdate
2()) declare @UID_Job varchar(38) = null declare @GenProcID varchar(38)= dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted
3) goto start if exists (select top 1 1 from deleted) goto start return start: if update(SystemSyncMode) or UPDATE(SystemSyncKeyColumns) or UPDATE(UID_SystemSyncConfigCLRType
4) begin if exists (select top 1 1 from DialogTable t join deleted d on t.UID_DialogTable = d.UID_DialogTable where t.SystemSyncMode <> d.SystemSyncMode
5 or ISNULL(t.SystemSyncKeyColumns,'') <> ISNULL(d.SystemSyncKeyColumns,'') or ISNULL(t.UID_SystemSyncConfigCLRType,'') <> ISNULL(d.UID_SystemSyncConfigCLRType
6,'') ) begin select top 1 @UID_Job = q.UID_Job from JobQueue q where q.JobChainName = 'Created by QBMDBQueueProcess: fire event UpdateSystemSyncs for object type DialogDatabase'
7 and q.Ready2EXE = N'TRUE'  if @UID_Job > ' '  begin  update JobQueue set StartAt = @Starten where UID_Job = @UID_Job end else begin   exec QBM_PJobCreate_HOFireEvent
8 'DialogDatabase', 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end  END TRY BEGIN
9 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
10