Back to OIM Explorer

dbo.QBM_TUAssembly_JobChain

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on JobChain. Bulk DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 8; Bulk DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 8; Bulk DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 10; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.702 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 -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 8
  • Bulk DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 8
  • Bulk DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 10
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: JobChain

Typed Edges

  • queues DBQueue task QBM_ZScriptAssemblyReset at line 8 Bulk DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 8
  • queues DBQueue task QBM_ZScriptAssemblyReset at line 10 Bulk DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 10
  • trigger on table JobChain Trigger parent table: JobChain
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGITableName source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_TUAssembly_Job source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL82 lines
1CREATE trigger QBM_TUAssembly_JobChain2  ON JobChain FOR3UPDATE 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    IF EXISTS(13      SELECT TOP 1 114      FROM deleted)15    GOTO start16    RETURN start:17    IF18    UPDATE(GenCondition) OR19    UPDATE(PreCode) OR20    UPDATE(ProcessDisplay) OR21    UPDATE(Name) OR22    UPDATE(UID_Job) OR23    UPDATE(LimitationCount) OR24    UPDATE(LimitationWarning) OR25    UPDATE(PreProcessorCondition) OR26    UPDATE(NoGenerate) OR27    UPDATE(UID_DialogTable)28    BEGIN29      DECLARE @DBQueueElements_01 QBM_YDBQueueRaw30      INSERT INTO @DBQueueElements_01(Object,31      SubObject,32      GenProcID)33      SELECT34        'JobGen',35        dbo.QBM_FGITableName(i.UID_DialogTable),36        @GenProcID37      FROM inserted i38      JOIN JobEventGen e39        ON i.UID_JobChain = e.UID_JobChain40      WHERE41        i.IsDeactivatedByPreProcessor = 0 AND i.NoGenerate = 042      UNION43      SELECT44        'JobGen',45        dbo.QBM_FGITableName(i.UID_DialogTable),46        @GenProcID47      FROM deleted i48      JOIN JobChain c49        ON i.UID_JobChain = c.UID_JobChain50      JOIN JobEventGen e51        ON i.UID_JobChain = e.UID_JobChain52      WHERE53        i.IsDeactivatedByPreProcessor = 0 AND(i.NoGenerate = 0 OR c.NoGenerate = 0)54      EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset',55        @DBQueueElements_0156    END57    IF58    UPDATE(IsDeactivatedByPreProcessor)59    BEGIN60      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw61      INSERT INTO @DBQueueElements_02(Object,62      SubObject,63      GenProcID)64      SELECT65        'JobGen',66        dbo.QBM_FGITableName(i.UID_DialogTable),67        @GenProcID68      FROM inserted i69      JOIN JobEventGen e70        ON i.UID_JobChain = e.UID_JobChain71      EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset',72        @DBQueueElements_0273    END74  END TRY75  BEGIN CATCH76    EXEC QBM_PSessionErrorAdd DEFAULT77    RAISERROR('',78    18,79    1)80      WITH NOWAIT81  END CATCH82END
Open raw exported source
SQL ยท Raw12 lines
1 create   trigger QBM_TUAssembly_JobChain on JobChain  for Update not for Replication as begin  declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: if update(GenCondition3) or update(PreCode) or update(ProcessDisplay) or update(Name) or update(UID_Job) or update(LimitationCount) or update(LimitationWarning) or update(PreProcessorCondition4) or update(NoGenerate) or update(UID_DialogTable) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject,5 GenProcID) select 'JobGen', dbo.QBM_FGITableName(i.UID_DialogTable) , @GenProcID from inserted i join JobEventGen e on i.UID_JobChain = e.UID_JobChain6 where i.IsDeactivatedByPreProcessor = 0 and i.NoGenerate = 0 union select 'JobGen', dbo.QBM_FGITableName(i.UID_DialogTable) , @GenProcID from deleted 7i join JobChain c on i.UID_JobChain = c.UID_JobChain join JobEventGen e on i.UID_JobChain = e.UID_JobChain where i.IsDeactivatedByPreProcessor = 0 and 8(i.NoGenerate = 0 or c.NoGenerate = 0 ) exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset', @DBQueueElements_01  end if update(IsDeactivatedByPreProcessor9) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02(Object, SubObject, GenProcID) select 'JobGen', dbo.QBM_FGITableName10(i.UID_DialogTable) , @GenProcID from inserted i join JobEventGen e on i.UID_JobChain = e.UID_JobChain exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset'11, @DBQueueElements_02 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 12