Back to OIM Explorer

dbo.TSB_TUTSBSpecificGroupBehavior

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on TSBSpecificGroupBehavior. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 12; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 12; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 12; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 12

Source: sandbox-db sys.sql_modules

Source size: 4.188 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 12
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 12
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 12
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 12
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 17
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 17
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 17
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 21
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 21
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 26
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: TSBSpecificGroupBehavior

Typed Edges

  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB at line 12 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 12
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB1 at line 12 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 12
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 12 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 12
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 12 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 12
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB1 at line 17 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 17
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 17 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 17
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 17 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 17
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 21 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 21
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 21 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 21
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 26 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 26
  • trigger on table TSBSpecificGroupBehavior Trigger parent table: TSBSpecificGroupBehavior
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL174 lines
1CREATE trigger TSB_TUTSBSpecificGroupBehavior2  ON TSBSpecificGroupBehavior FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  DECLARE @ReallyChanged QBM_YParameterList8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM inserted)12    GOTO start13    IF EXISTS(14      SELECT TOP 1 115      FROM deleted)16    GOTO start17    RETURN start:18    IF NOT(19      UPDATE(PFDInheritOverwrite) OR20    UPDATE(PTDInheritOverwrite) OR21    UPDATE(PSIInheritOverwrite) OR22    UPDATE(PMDInheritOverwrite) OR23    UPDATE(ADAInheritOverwrite))24    BEGIN25      GOTO EndLabel26    END27    INSERT INTO @ReallyChanged(Parameter1)28    SELECT ovr.ObjectKeyGroup29    FROM TSBSpecificGroupBehavior ovr30    JOIN deleted i31      ON ovr.UID_TSBSpecificGroupBehavior = i.UID_TSBSpecificGroupBehavior32    WHERE33      isnull(ovr.PFDInheritOverwrite,34    0) <> isnull(i.PFDInheritOverwrite,35    0) OR isnull(ovr.PTDInheritOverwrite,36    0) <> isnull(i.PTDInheritOverwrite,37    0) OR isnull(ovr.PSIInheritOverwrite,38    0) <> isnull(i.PSIInheritOverwrite,39    0) OR isnull(ovr.PMDInheritOverwrite,40    0) <> isnull(i.PMDInheritOverwrite,41    0) OR isnull(ovr.ADAInheritOverwrite,42    0) <> isnull(i.ADAInheritOverwrite,43    0)44    IF @@ROWCOUNT = 045    BEGIN46      GOTO EndLabel47    END48    DECLARE @GUIDUnsGroupB00 QBM_YSingleGUID49    INSERT INTO @GUIDUnsGroupB00(UID_SingleGuid)50    SELECT g.UID_UNSGroupB51    FROM UNSGroupB g52    JOIN @ReallyChanged ch53      ON g.XObjectKey = ch.Parameter154    IF @@ROWCOUNT > 055    BEGIN56      DECLARE @DBQueueElements_00 QBM_YDBQueueRaw57      INSERT INTO @DBQueueElements_00(object,58      subobject,59      genprocid)60      SELECT61        x.uid,62        NULL,63        @GenProcID64      FROM(65      SELECT uig.UID_UNSAccountB AS uid66      FROM UNSAccountBInUNSGroupB uig67      JOIN @GUIDUnsGroupB00 gg68        ON uig.UID_UNSGroupB = gg.UID_SingleGuid69      UNION70      SELECT uig.UID_UNSAccountB AS uid71      FROM UNSAccountBHasUNSGroupB uig72      JOIN @GUIDUnsGroupB00 gg73        ON uig.UID_UNSGroupB = gg.UID_SingleGuid) AS x74      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB',75        @DBQueueElements_0076    END77    DECLARE @GUIDUnsGroupB01 QBM_YSingleGUID78    INSERT INTO @GUIDUnsGroupB01(UID_SingleGuid)79    SELECT g.UID_UNSGroupB180    FROM UNSGroupB1 g81    JOIN @ReallyChanged ch82      ON g.XObjectKey = ch.Parameter183    IF @@ROWCOUNT > 084    BEGIN85      DECLARE @DBQueueElements_01 QBM_YDBQueueRaw86      INSERT INTO @DBQueueElements_01(object,87      subobject,88      genprocid)89      SELECT90        x.uid,91        NULL,92        @GenProcID93      FROM(94      SELECT uig.UID_UNSAccountB AS uid95      FROM UNSAccountBInUNSGroupB1 uig96      JOIN @GUIDUnsGroupB01 gg97        ON uig.UID_UNSGroupB1 = gg.UID_SingleGuid98      UNION99      SELECT uig.UID_UNSAccountB AS uid100      FROM UNSAccountBHasUNSGroupB1 uig101      JOIN @GUIDUnsGroupB01 gg102        ON uig.UID_UNSGroupB1 = gg.UID_SingleGuid) AS x103      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1',104        @DBQueueElements_01105    END106    DECLARE @GUIDUnsGroupB02 QBM_YSingleGUID107    INSERT INTO @GUIDUnsGroupB02(UID_SingleGuid)108    SELECT g.UID_UNSGroupB2109    FROM UNSGroupB2 g110    JOIN @ReallyChanged ch111      ON g.XObjectKey = ch.Parameter1112    IF @@ROWCOUNT > 0113    BEGIN114      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw115      INSERT INTO @DBQueueElements_02(object,116      subobject,117      genprocid)118      SELECT119        x.uid,120        NULL,121        @GenProcID122      FROM(123      SELECT uig.UID_UNSAccountB AS uid124      FROM UNSAccountBInUNSGroupB2 uig125      JOIN @GUIDUnsGroupB02 gg126        ON uig.UID_UNSGroupB2 = gg.UID_SingleGuid127      UNION128      SELECT uig.UID_UNSAccountB AS uid129      FROM UNSAccountBHasUNSGroupB2 uig130      JOIN @GUIDUnsGroupB02 gg131        ON uig.UID_UNSGroupB2 = gg.UID_SingleGuid) AS x132      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2',133        @DBQueueElements_02134    END135    DECLARE @GUIDUnsGroupB03 QBM_YSingleGUID136    INSERT INTO @GUIDUnsGroupB03(UID_SingleGuid)137    SELECT g.UID_UNSGroupB3138    FROM UNSGroupB3 g139    JOIN @ReallyChanged ch140      ON g.XObjectKey = ch.Parameter1141    IF @@ROWCOUNT > 0142    BEGIN143      DECLARE @DBQueueElements_03 QBM_YDBQueueRaw144      INSERT INTO @DBQueueElements_03(object,145      subobject,146      genprocid)147      SELECT148        x.uid,149        NULL,150        @GenProcID151      FROM(152      SELECT uig.UID_UNSAccountB AS uid153      FROM UNSAccountBInUNSGroupB3 uig154      JOIN @GUIDUnsGroupB03 gg155        ON uig.UID_UNSGroupB3 = gg.UID_SingleGuid156      UNION157      SELECT uig.UID_UNSAccountB AS uid158      FROM UNSAccountBHasUNSGroupB3 uig159      JOIN @GUIDUnsGroupB03 gg160        ON uig.UID_UNSGroupB3 = gg.UID_SingleGuid) AS x161      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3',162        @DBQueueElements_03163    END164  END TRY165  BEGIN CATCH166    EXEC QBM_PSessionErrorAdd DEFAULT167    RAISERROR('',168    18,169    1)170      WITH NOWAIT171  END CATCH172  endLabel:173  RETURN174END
Open raw exported source
SQL ยท Raw28 lines
1create   trigger TSB_TUTSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for update not for Replication as begin declare @GenProcID varchar(382) = dbo.QBM_FGISessionContext('') declare @ReallyChanged QBM_YParameterList  BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select3 top 1 1 from deleted) goto start return start: if not (update( PFDInheritOverwrite ) or update( PTDInheritOverwrite ) or update( PSIInheritOverwrite )4 or update( PMDInheritOverwrite ) or update( ADAInheritOverwrite ) ) begin goto EndLabel end insert into @ReallyChanged(Parameter1) select ovr.ObjectKeyGroup5 from TSBSpecificGroupBehavior ovr join deleted i on ovr.UID_TSBSpecificGroupBehavior = i.UID_TSBSpecificGroupBehavior where isnull(ovr.PFDInheritOverwrite6,0) <> isnull(i.PFDInheritOverwrite, 0) or isnull(ovr.PTDInheritOverwrite,0) <> isnull(i.PTDInheritOverwrite, 0) or isnull(ovr.PSIInheritOverwrite,0) <>7 isnull(i.PSIInheritOverwrite, 0) or isnull(ovr.PMDInheritOverwrite,0) <> isnull(i.PMDInheritOverwrite, 0) or isnull(ovr.ADAInheritOverwrite,0) <> isnull8(i.ADAInheritOverwrite, 0) if @@ROWCOUNT = 0 begin goto EndLabel end declare @GUIDUnsGroupB00 QBM_YSingleGUID insert into @GUIDUnsGroupB00(UID_SingleGuid9) select g.UID_UNSGroupB from UNSGroupB g join @ReallyChanged ch on g.XObjectKey = ch.Parameter1 if @@ROWCOUNT > 0 begin declare @DBQueueElements_00 QBM_YDBQueueRaw10 insert into @DBQueueElements_00 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_UNSAccountB as uid from UNSAccountBInUNSGroupB11 uig join @GUIDUnsGroupB00 gg on uig.UID_UNSGroupB = gg.UID_SingleGuid union select uig.UID_UNSAccountB as uid from UNSAccountBHasUNSGroupB uig join @GUIDUnsGroupB0012 gg on uig.UID_UNSGroupB = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB', @DBQueueElements_00 end  declare @GUIDUnsGroupB0113 QBM_YSingleGUID insert into @GUIDUnsGroupB01(UID_SingleGuid) select g.UID_UNSGroupB1 from UNSGroupB1 g join @ReallyChanged ch on g.XObjectKey = ch.Parameter114 if @@ROWCOUNT > 0 begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null,15 @GenProcID from ( select uig.UID_UNSAccountB as uid from UNSAccountBInUNSGroupB1 uig join @GUIDUnsGroupB01 gg on uig.UID_UNSGroupB1 = gg.UID_SingleGuid16 union select uig.UID_UNSAccountB as uid from UNSAccountBHasUNSGroupB1 uig join @GUIDUnsGroupB01 gg on uig.UID_UNSGroupB1 = gg.UID_SingleGuid ) as x exec17 QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1', @DBQueueElements_01 end  declare @GUIDUnsGroupB02 QBM_YSingleGUID insert into @GUIDUnsGroupB0218(UID_SingleGuid) select g.UID_UNSGroupB2 from UNSGroupB2 g join @ReallyChanged ch on g.XObjectKey = ch.Parameter1 if @@ROWCOUNT > 0 begin declare @DBQueueElements_0219 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_UNSAccountB as uid20 from UNSAccountBInUNSGroupB2 uig join @GUIDUnsGroupB02 gg on uig.UID_UNSGroupB2 = gg.UID_SingleGuid union select uig.UID_UNSAccountB as uid from UNSAccountBHasUNSGroupB221 uig join @GUIDUnsGroupB02 gg on uig.UID_UNSGroupB2 = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2', @DBQueueElements_0222 end  declare @GUIDUnsGroupB03 QBM_YSingleGUID insert into @GUIDUnsGroupB03(UID_SingleGuid) select g.UID_UNSGroupB3 from UNSGroupB3 g join @ReallyChanged23 ch on g.XObjectKey = ch.Parameter1 if @@ROWCOUNT > 0 begin declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject24, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_UNSAccountB as uid from UNSAccountBInUNSGroupB3 uig join @GUIDUnsGroupB03 gg on uig.UID_UNSGroupB325 = gg.UID_SingleGuid union select uig.UID_UNSAccountB as uid from UNSAccountBHasUNSGroupB3 uig join @GUIDUnsGroupB03 gg on uig.UID_UNSGroupB3 = gg.UID_SingleGuid26 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3', @DBQueueElements_03 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR27 ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 28