Back to OIM Explorer

dbo.ADS_TUTSBBehavior

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on TSBBehavior. Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 9; Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 9; Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 11; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.875 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-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 9
  • Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 9
  • Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 11
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: TSBBehavior

Typed Edges

  • queues DBQueue task ADS_ZAccountInADSGroup at line 9 Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 9
  • queues DBQueue task ADS_ZContactInADSGroup at line 9 Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 9
  • queues DBQueue task ADS_ZContactInADSGroup at line 11 Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 11
  • trigger on table TSBBehavior Trigger parent table: TSBBehavior
  • 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

SQL82 lines
1CREATE trigger ADS_TUTSBBehavior2  ON TSBBehavior FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @TSBBehaviorsToCheck QBM_YSingleGUID7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    IF EXISTS(13      SELECT TOP 1 114      FROM deleted)15    GOTO start16    RETURN start:17    DECLARE @GenProcID varchar(38)18    SELECT @GenProcID = dbo.QBM_FGISessionContext('')19    IF20    UPDATE(PTDInheritGroup) OR21    UPDATE(PFDInheritGroup) OR22    UPDATE(PMDInheritGroup) OR23    UPDATE(PSIInheritGroup) OR24    UPDATE(ADAInheritGroup)25    BEGIN26      INSERT INTO @TSBBehaviorsToCheck(UID_SingleGuid)27      SELECT28        DISTINCT r.uid_TSBBehavior29      FROM TSBBehavior r30      JOIN deleted d31        ON r.uid_TSBBehavior = d.uid_TSBBehavior32      WHERE33        (isnull(r.PTDInheritGroup, 0) <> isnull(d.PTDInheritGroup, 0) OR isnull(r.PFDInheritGroup, 0) <> isnull(d.PFDInheritGroup,34      0) OR isnull(r.PMDInheritGroup, 0) <> isnull(d.PMDInheritGroup, 0) OR isnull(r.PSIInheritGroup, 0) <> isnull(d.PSIInheritGroup,35      0) OR isnull(r.ADAInheritGroup, 0) <> isnull(d.ADAInheritGroup, 0))36      IF 0 <(37        SELECT count(*)38      FROM @TSBBehaviorsToCheck)39      BEGIN40        DECLARE @DBQueueElements_01 QBM_YDBQueueRaw41        INSERT INTO @DBQueueElements_01(object,42        subobject,43        genprocid)44        SELECT45          x.uid,46          NULL,47          @GenProcID48        FROM(49        SELECT a.UID_ADSAccount AS uid50        FROM ADSAccount a51        JOIN @TSBBehaviorsToCheck c52          ON a.UID_TSBBehavior = c.UID_SingleGuid) AS x53        EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup',54          @DBQueueElements_0155        DECLARE @DBQueueElements_02 QBM_YDBQueueRaw56        INSERT INTO @DBQueueElements_02(object,57        subobject,58        genprocid)59        SELECT60          x.uid,61          NULL,62          @GenProcID63        FROM(64        SELECT a.UID_ADSContact AS uid65        FROM ADSContact a66        JOIN @TSBBehaviorsToCheck c67          ON a.UID_TSBBehavior = c.UID_SingleGuid) AS x68        EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup',69          @DBQueueElements_0270      END71    END72  END TRY73  BEGIN CATCH74    EXEC QBM_PSessionErrorAdd DEFAULT75    RAISERROR('',76    18,77    1)78      WITH NOWAIT79  END CATCH80  ende:81  RETURN82END
Open raw exported source
SQL ยท Raw13 lines
1 create   trigger ADS_TUTSBBehavior on TSBBehavior  for Update not for Replication as begin  declare @TSBBehaviorsToCheck QBM_YSingleGUID     BEGIN2 TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(383) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(PTDInheritGroup) or update(PFDInheritGroup) or update(PMDInheritGroup) or update(PSIInheritGroup4) or update(ADAInheritGroup) begin insert into @TSBBehaviorsToCheck (UID_SingleGuid ) select distinct r.uid_TSBBehavior from TSBBehavior r join deleted5 d on r.uid_TSBBehavior = d.uid_TSBBehavior where (isnull(r.PTDInheritGroup,0) <> isnull(d.PTDInheritGroup,0) or isnull(r.PFDInheritGroup,0) <> isnull(d.PFDInheritGroup6,0) or isnull(r.PMDInheritGroup,0) <> isnull(d.PMDInheritGroup,0) or isnull(r.PSIInheritGroup,0) <> isnull(d.PSIInheritGroup,0) or isnull(r.ADAInheritGroup7,0) <> isnull(d.ADAInheritGroup,0) ) if 0 < (select count(*) from @TSBBehaviorsToCheck) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_018 (object, subobject, genprocid) select x.uid, null, @GenProcID from (  select a.UID_ADSAccount as uid from ADSAccount a join @TSBBehaviorsToCheck c on 9a.UID_TSBBehavior = c.UID_SingleGuid  ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_01 declare @DBQueueElements_0210 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from (  select a.UID_ADSContact as uid from11 ADSContact a join @TSBBehaviorsToCheck c on a.UID_TSBBehavior = c.UID_SingleGuid  ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_0212 end end    END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 13