Back to OIM Explorer

dbo.ADS_TITSBSpecificGroupBehavior

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on TSBSpecificGroupBehavior. Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 6; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 6; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 8; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.414 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 -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 6
  • Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 6
  • Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 8
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: TSBSpecificGroupBehavior

Typed Edges

  • queues DBQueue task ADS_ZContactInADSGroup at line 6 Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 6
  • queues DBQueue task ADS_ZAccountInADSGroup at line 6 Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 6
  • queues DBQueue task ADS_ZAccountInADSGroup at line 8 Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 8
  • 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

SQL62 lines
1CREATE trigger ADS_TITSBSpecificGroupBehavior2  ON TSBSpecificGroupBehavior FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GUIDADSGroup QBM_YSingleGUID14    INSERT INTO @GUIDADSGroup(UID_SingleGuid)15    SELECT g.UID_ADSGroup16    FROM ADSGroup g17    JOIN inserted i18      ON g.XObjectKey = i.ObjectKeyGroup19    IF @@ROWCOUNT > 020    BEGIN21      DECLARE @DBQueueElements_ADSContactInADSGroup QBM_YDBQueueRaw22      INSERT INTO @DBQueueElements_ADSContactInADSGroup(object,23      subobject,24      genprocid)25      SELECT26        x.uid,27        NULL,28        @GenProcID29      FROM(30      SELECT uig.UID_ADSContact AS uid31      FROM ADSContactInADSGroup uig32      JOIN @GUIDADSGroup gg33        ON uig.UID_ADSGroup = gg.UID_SingleGuid) AS x34      EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup',35        @DBQueueElements_ADSContactInADSGroup36      DECLARE @DBQueueElements_ADSAccountInADSGroup QBM_YDBQueueRaw37      INSERT INTO @DBQueueElements_ADSAccountInADSGroup(object,38      subobject,39      genprocid)40      SELECT41        x.uid,42        NULL,43        @GenProcID44      FROM(45      SELECT uig.UID_ADSAccount AS uid46      FROM ADSAccountInADSGroup uig47      JOIN @GUIDADSGroup gg48        ON uig.UID_ADSGroup = gg.UID_SingleGuid) AS x49      EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup',50        @DBQueueElements_ADSAccountInADSGroup51    END52  END TRY53  BEGIN CATCH54    EXEC QBM_PSessionErrorAdd DEFAULT55    RAISERROR('',56    18,57    1)58      WITH NOWAIT59  END CATCH60  EndLabel:61  RETURN62END
Open raw exported source
SQL ยท Raw11 lines
1 create   trigger ADS_TITSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for insert not for Replication as begin declare @GenProcID varchar2(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @GUIDADSGroup QBM_YSingleGUID 3insert into @GUIDADSGroup(UID_SingleGuid) select g.UID_ADSGroup from ADSGroup g join inserted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT > 0 begin4 declare @DBQueueElements_ADSContactInADSGroup QBM_YDBQueueRaw insert into @DBQueueElements_ADSContactInADSGroup (object, subobject, genprocid) select 5x.uid, null, @GenProcID from ( select uig.UID_ADSContact as uid from ADSContactInADSGroup uig join @GUIDADSGroup gg on uig.UID_ADSGroup = gg.UID_SingleGuid6 ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_ADSContactInADSGroup declare @DBQueueElements_ADSAccountInADSGroup 7QBM_YDBQueueRaw insert into @DBQueueElements_ADSAccountInADSGroup (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_ADSAccount8 as uid from ADSAccountInADSGroup uig join @GUIDADSGroup gg on uig.UID_ADSGroup = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup'9, @DBQueueElements_ADSAccountInADSGroup end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH EndLabel:10 return end 11