Back to OIM Explorer

dbo.QBM_TDJobqueue

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on JobQueue. Trigger parent table: JobQueue

Source: sandbox-db sys.sql_modules

Source size: 1.368 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: JobQueue

Typed Edges

  • trigger on table JobQueue Trigger parent table: JobQueue
  • references source dbo.QBM_FCVStringToGUID source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PJobQueueOverviewSetInv source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL66 lines
1CREATE trigger QBM_TDJobqueue2  ON JobQueue FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  DECLARE @CountElementAffected int = 08  DECLARE @DeletedElements QBM_YParameterList9  BEGIN TRY10    IF EXISTS(11      SELECT TOP 1 112      FROM deleted)13    GOTO start14    RETURN start:15    INSERT INTO @DeletedElements(Parameter1,16    Parameter2,17    ContentShort)18    SELECT19      d.UID_Job,20      d.UID_Tree,21      d.Queue22    FROM deleted d23    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw24    INSERT INTO @DBQueueElements_01(Object,25    SubObject,26    GenProcID)27    SELECT28      dbo.QBM_FCVStringToGUID('',29      x.QueueName),30      NULL,31      @GenProcID32    FROM(33    SELECT d.ContentShort AS QueueName34    FROM @DeletedElements d35    GROUP BY d.ContentShort) AS x36    DELETE @DBQueueElements_0137    FROM @DBQueueElements_01 q38    JOIN QBMJobqueueOverview o39      WITH(readpast)40      ON q.Object = o.UID_QBMJobqueueOverview41    WHERE42      o.IsInvalid = 143    IF EXISTS(44      SELECT TOP 1 145      FROM @DBQueueElements_01)46    BEGIN47      EXEC QBM_PJobQueueOverviewSetInv @DBQueueElements_0148    END49    DELETE QBMElementAffectedByJob50    FROM @DeletedElements d51    JOIN QBMElementAffectedByJob a52      ON d.Parameter1 = a.UID_Job53    SELECT @CountElementAffected = @@rowcount54    DELETE JobtreeParamColl55    FROM @DeletedElements d56    JOIN JobtreeParamColl a57      ON d.Parameter2 = a.UID_Tree58  END TRY59  BEGIN CATCH60    EXEC QBM_PSessionErrorAdd DEFAULT61    RAISERROR('',62    18,63    1)64      WITH NOWAIT65  END CATCH66END
Open raw exported source
SQL ยท Raw10 lines
1  create   trigger QBM_TDJobqueue on JobQueue  for delete not for Replication as begin   declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext2('') declare @CountElementAffected int = 0 declare @DeletedElements QBM_YParameterList    BEGIN TRY if exists (select top 1 1 from deleted) goto start 3return start: insert into @DeletedElements (Parameter1, Parameter2, ContentShort) select d.UID_Job, d.UID_Tree, d.Queue from deleted d  declare @DBQueueElements_014 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select dbo.QBM_FCVStringToGUID('', x.QueueName), null, @GenProcID from (5 select d.ContentShort as QueueName from @DeletedElements d group by d.ContentShort  ) as x  delete  @DBQueueElements_01 from @DBQueueElements_01 q join6 QBMJobqueueOverview o with (readpast) on q.Object = o.UID_QBMJobqueueOverview where o.IsInvalid = 1 if exists (select top 1 1 from @DBQueueElements_017 ) begin   exec QBM_PJobQueueOverviewSetInv @DBQueueElements_01 end    delete QBMElementAffectedByJob from @DeletedElements d join QBMElementAffectedByJob8 a on d.Parameter1  = a.UID_Job select @CountElementAffected = @@rowcount   delete JobtreeParamColl from @DeletedElements d join JobtreeParamColl a on 9d.Parameter2  = a.UID_Tree  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 10