Back to OIM Explorer

dbo.DPR_TDDPRSystemSyncDependency

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DPRSystemSyncDependency. HOFireEvent -> DialogDatabase.UpdateSystemSyncs at line 5; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*; Trigger parent table: DPRSystemSyncDependency

Source: sandbox-db sys.sql_modules

Source size: 988 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOFireEvent -> DialogDatabase.UpdateSystemSyncs at line 5
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*
  • Trigger parent table: DPRSystemSyncDependency

Typed Edges

  • fires event DialogDatabase.UpdateSystemSyncs HOFireEvent -> DialogDatabase.UpdateSystemSyncs at line 5
  • trigger on table DPRSystemSyncDependency Trigger parent table: DPRSystemSyncDependency
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL51 lines
1CREATE trigger DPR_TDDPRSystemSyncDependency2  ON DPRSystemSyncDependency FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @Starten datetime = dateadd(ss,7  100,8  getutcdate())9  DECLARE @UID_Job varchar(38) = NULL10  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')11  BEGIN TRY12    IF EXISTS(13      SELECT TOP 1 114      FROM inserted)15    GOTO start16    IF EXISTS(17      SELECT TOP 1 118      FROM deleted)19    GOTO start20    RETURN start:21    SELECT TOP 1 @UID_Job = q.UID_Job22    FROM JobQueue q23    WHERE24      q.JobChainName = 'Created by QBMDBQueueProcess: fire event UpdateSystemSyncs for object type DialogDatabase' AND q.Ready2EXE = N 'TRUE'25    IF @UID_Job > ' '26    BEGIN27      UPDATE JobQueue28      SET StartAt = @Starten29      WHERE30        UID_Job = @UID_Job31    END32    ELSE33    BEGIN34      EXEC QBM_PJobCreate_HOFireEvent 'DialogDatabase',35      'IsMainDatabase = 1',36      'UpdateSystemSyncs',37        @GenProcID,38        @ObjectKeysAffected = DEFAULT,39        @Startat = @Starten40    END41  END TRY42  BEGIN CATCH43    EXEC QBM_PSessionErrorAdd DEFAULT44    RAISERROR('',45    18,46    1)47      WITH NOWAIT48  END CATCH49  ende:50  RETURN51END
Open raw exported source
SQL ยท Raw8 lines
1 create   trigger DPR_TDDPRSystemSyncDependency on DPRSystemSyncDependency  for delete 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 (select3 top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: select top 1 @UID_Job = q.UID_Job from JobQueue q where4 q.JobChainName = 'Created by QBMDBQueueProcess: fire event UpdateSystemSyncs for object type DialogDatabase' and q.Ready2EXE = N'TRUE' if @UID_Job > ' '5  begin  update JobQueue set StartAt = @Starten where UID_Job = @UID_Job end else begin   exec QBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1'6, 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR7 ('', 18, 1) WITH NOWAIT END CATCH ende: return end 8