dbo.DPR_TUDPRSystemSyncDependency

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