Back to OIM Explorer

dbo.QBM_TIJobAutoStart

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on JobAutoStart. Trigger parent table: JobAutoStart

Source: sandbox-db sys.sql_modules

Source size: 793 characters

Interpretation

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

Relations

  • Trigger parent table: JobAutoStart

Typed Edges

  • trigger on table JobAutoStart Trigger parent table: JobAutoStart
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSQLCheckExecutable source text reference
  • references source dbo.QBM_TIJob source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL40 lines
1CREATE trigger QBM_TIJobAutoStart2  ON JobAutoStart FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @SQLToCheck QBM_YParameterList7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GenProcID varchar(38)14    SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    INSERT INTO @SQLToCheck(Parameter1,16    ContentFull)17    SELECT18      c.XObjectKey,19      'select top 1 1 as columnvalue from ' + t.TableName + '20		 where (21		 ' + c.WhereClause + '22		 )'23    FROM inserted c24    JOIN QBMEvent et25      ON et.UID_QBMEvent = c.UID_QBMEvent26    JOIN DialogTable t27      ON et.UID_DialogTable = t.UID_DialogTable28    WHERE29      c.WhereClause > ' '30    EXEC QBM_PSQLCheckExecutable @SQLToCheck,31      @RaiseError = 132  END TRY33  BEGIN CATCH34    EXEC QBM_PSessionErrorAdd DEFAULT35    RAISERROR('',36    18,37    1)38      WITH NOWAIT39  END CATCH40END
Open raw exported source
SQL ยท Raw10 lines
1   create   trigger QBM_TIJobAutoStart on JobAutoStart  for INSERT not for Replication as begin declare @SQLToCheck QBM_YParameterList BEGIN TRY2 if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  insert3 into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '4		 where (5		 ' + c.WhereClause6 + '7		 )' from inserted c  join QBMEvent et on et.UID_QBMEvent = c.UID_QBMEvent join DialogTable t on et.UID_DialogTable = t.UID_DialogTable where c.WhereClause8 > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT9 END CATCH end 10