Back to OIM Explorer

dbo.QBM_TUJobAutoStart

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on JobAutoStart. Trigger parent table: JobAutoStart

Source: sandbox-db sys.sql_modules

Source size: 973 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_TUJob source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL54 lines
1CREATE trigger QBM_TUJobAutoStart2  ON JobAutoStart FOR3UPDATE 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    IF16    UPDATE(WhereClause)17    BEGIN18      INSERT INTO @SQLToCheck(Parameter1,19      ContentFull)20      SELECT21        c.XObjectKey,22        'select top 1 1 as columnvalue from ' + t.TableName + '23		 where (24		 ' + c.WhereClause + '25		 )'26      FROM inserted c27      JOIN QBMEvent et28        ON et.UID_QBMEvent = c.UID_QBMEvent29      JOIN DialogTable t30        ON et.UID_DialogTable = t.UID_DialogTable31      WHERE32        c.WhereClause > ' '33      EXEC QBM_PSQLCheckExecutable @SQLToCheck,34        @RaiseError = 135    END36    IF37    UPDATE(UID_QBMEvent)38    BEGIN39      UPDATE DialogSchedule40      SET nextrun = NULL41      WHERE42        uid_DialogSchedule IN(43      SELECT uid_DialogSchedule44      FROM inserted)45    END46  END TRY47  BEGIN CATCH48    EXEC QBM_PSessionErrorAdd DEFAULT49    RAISERROR('',50    18,51    1)52      WITH NOWAIT53  END CATCH54END
Open raw exported source
SQL ยท Raw11 lines
1  create   trigger QBM_TUJobAutoStart on JobAutoStart  for update not for Replication as begin declare @SQLToCheck QBM_YParameterList BEGIN TRY 2if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if 3update(WhereClause) begin insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '4		 where (5		 '6 + c.WhereClause + '7		 )' from inserted c  join QBMEvent et on et.UID_QBMEvent = c.UID_QBMEvent join DialogTable t on et.UID_DialogTable = t.UID_DialogTable8 where c.WhereClause > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 end  if update(UID_QBMEvent) begin update DialogSchedule set nextrun9 = null where uid_DialogSchedule in (select uid_DialogSchedule from inserted) end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 1018, 1) WITH NOWAIT END CATCH end 11