Back to OIM Explorer

dbo.QBM_TDQBMServerHasDeployTarget

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on QBMServerHasDeployTarget. HOFireEvent -> QBMServer.DeployTargetChanged at line 6; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*; Trigger parent table: QBMServerHasDeployTarget

Source: sandbox-db sys.sql_modules

Source size: 1.059 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 -> QBMServer.DeployTargetChanged at line 6
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*
  • Trigger parent table: QBMServerHasDeployTarget

Typed Edges

  • fires event QBMServer.DeployTargetChanged HOFireEvent -> QBMServer.DeployTargetChanged at line 6
  • trigger on table QBMServerHasDeployTarget Trigger parent table: QBMServerHasDeployTarget
  • references source dbo.QBM_FCVStringToInt source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • 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_PJobCreate_HOFireEvent_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_TDQBMServer source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL50 lines
1CREATE trigger QBM_TDQBMServerHasDeployTarget2  ON QBMServerHasDeployTarget FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  DECLARE @EntriesToFire QBM_YParameterList8  DECLARE @DebugSwitch int = 09  DECLARE @ConfigparmAutoupdate int10  BEGIN TRY11    IF EXISTS(12      SELECT TOP 1 113      FROM deleted)14    GOTO start15    RETURN start:16    SELECT17      @ConfigparmAutoupdate = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\Autoupdate'),18      0)19    IF dbo.QBM_FGISessionContext('Fullsync') = ''20    BEGIN21      INSERT INTO @EntriesToFire(Parameter1)22      SELECT23        DISTINCT q.XObjectKey24      FROM deleted x25      JOIN QBMServer q26        ON x.UID_QBMServer = q.UID_QBMServer27      WHERE28        @ConfigparmAutoupdate = 129      IF @DebugSwitch > 030      BEGIN31        print '@EntriesToFire '32        SELECT *33        FROM @EntriesToFire34      END35      EXEC QBM_PJobCreate_HOFireEvent_L 'QBMServer',36        @EntriesToFire,37      'DeployTargetChanged',38        @GenProcID,39        @CheckForExisting = 1,40        @AdditionalObjectKeysAffected = DEFAULT41    END42  END TRY43  BEGIN CATCH44    EXEC QBM_PSessionErrorAdd DEFAULT45    RAISERROR('',46    18,47    1)48      WITH NOWAIT49  END CATCH50END
Open raw exported source
SQL ยท Raw8 lines
1 create   trigger QBM_TDQBMServerHasDeployTarget on QBMServerHasDeployTarget  for Delete not for Replication as begin  declare @GenProcID varchar2(38) = dbo.QBM_FGISessionContext('')  declare @EntriesToFire QBM_YParameterList declare @DebugSwitch int = 0 declare @ConfigparmAutoupdate int BEGIN TRY3 if exists (select top 1 1 from deleted) goto start return start: select @ConfigparmAutoupdate = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\Autoupdate'4), 0)  if dbo.QBM_FGISessionContext ('Fullsync') = '' begin insert into @EntriesToFire (Parameter1) select distinct q.XObjectKey from deleted x join QBMServer5 q on x.UID_QBMServer = q.UID_QBMServer where @ConfigparmAutoupdate = 1 if @DebugSwitch > 0 begin print '@EntriesToFire ' select * from @EntriesToFire 6end exec QBM_PJobCreate_HOFireEvent_L 'QBMServer', @EntriesToFire ,'DeployTargetChanged', @GenProcID , @CheckForExisting = 1 , @AdditionalObjectKeysAffected7 = DEFAULT end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 8