Back to OIM Explorer

dbo.QBM_TUJobParameter

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on JobParameter. Trigger parent table: JobParameter

Source: sandbox-db sys.sql_modules

Source size: 1.756 characters

Interpretation

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

Relations

  • Trigger parent table: JobParameter

Typed Edges

  • trigger on table JobParameter Trigger parent table: JobParameter
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_TUJob source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL79 lines
1CREATE trigger QBM_TUJobParameter2  ON JobParameter FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @XUser nvarchar(64) = object_name(@@procid)7  DECLARE @Xdate datetime = getutcdate()8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM inserted)12    GOTO start13    IF EXISTS(14      SELECT TOP 1 115      FROM deleted)16    GOTO start17    RETURN start:18    DECLARE @GenProcID varchar(38)19    SELECT @GenProcID = dbo.QBM_FGISessionContext('')20    IF21    UPDATE(IsCrypted)22    BEGIN23      UPDATE JobRunParameter24      SET IsCrypted = 1,25      XDateUpdated = @Xdate,26      XUserUpdated = @XUser27      FROM JobParameter p28      JOIN deleted d29        ON p.UID_JobParameter = d.UID_JobParameter30      JOIN Job j31        ON j.UID_JobTask = p.UID_JobTask32      JOIN JobRunParameter rp33        ON rp.UID_Job = j.UID_Job AND rp.UID_JobParameter = p.UID_JobParameter34      WHERE35        p.IsCrypted = 1 AND rp.IsCrypted = 0 AND d.IsCrypted = 036    END37    IF38    UPDATE(IsHidden)39    BEGIN40      UPDATE JobRunParameter41      SET IsHidden = 1,42      XDateUpdated = @Xdate,43      XUserUpdated = @XUser44      FROM JobParameter p45      JOIN deleted d46        ON p.UID_JobParameter = d.UID_JobParameter47      JOIN Job j48        ON j.UID_JobTask = p.UID_JobTask49      JOIN JobRunParameter rp50        ON rp.UID_Job = j.UID_Job AND rp.UID_JobParameter = p.UID_JobParameter51      WHERE52        p.IsHidden = 1 AND rp.IsHidden = 0 AND d.IsHidden = 053    END54    IF55    UPDATE(IsPartialCrypted)56    BEGIN57      UPDATE JobRunParameter58      SET IsPartialCrypted = 1,59      XDateUpdated = @Xdate,60      XUserUpdated = @XUser61      FROM JobParameter p62      JOIN deleted d63        ON p.UID_JobParameter = d.UID_JobParameter64      JOIN Job j65        ON j.UID_JobTask = p.UID_JobTask66      JOIN JobRunParameter rp67        ON rp.UID_Job = j.UID_Job AND rp.UID_JobParameter = p.UID_JobParameter68      WHERE69        p.IsPartialCrypted = 1 AND rp.IsPartialCrypted = 0 AND d.IsPartialCrypted = 070    END71  END TRY72  BEGIN CATCH73    EXEC QBM_PSessionErrorAdd DEFAULT74    RAISERROR('',75    18,76    1)77      WITH NOWAIT78  END CATCH79END
Open raw exported source
SQL ยท Raw13 lines
1  create   trigger QBM_TUJobParameter on JobParameter  for Update not for Replication as begin declare @XUser nvarchar(64) = object_name(@@procid2) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start3 return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(IsCrypted) begin update JobRunParameter set IsCrypted4 = 1 , XDateUpdated = @Xdate , XUserUpdated = @XUser  from JobParameter p join deleted d on p.UID_JobParameter = d.UID_JobParameter  join Job j on j.UID_JobTask5 = p.UID_JobTask join JobRunParameter rp on rp.UID_Job = j.UID_Job and rp.UID_JobParameter = p.UID_JobParameter where p.IsCrypted = 1 and rp.IsCrypted 6= 0 and d.IsCrypted = 0 end if update(IsHidden) begin update JobRunParameter set IsHidden = 1 , XDateUpdated = @Xdate , XUserUpdated = @XUser  from JobParameter7 p join deleted d on p.UID_JobParameter = d.UID_JobParameter  join Job j on j.UID_JobTask = p.UID_JobTask join JobRunParameter rp on rp.UID_Job = j.UID_Job8 and rp.UID_JobParameter = p.UID_JobParameter where p.IsHidden = 1 and rp.IsHidden = 0 and d.IsHidden = 0 end if update(IsPartialCrypted) begin update 9JobRunParameter set IsPartialCrypted = 1 , XDateUpdated = @Xdate , XUserUpdated = @XUser  from JobParameter p join deleted d on p.UID_JobParameter = d.UID_JobParameter10  join Job j on j.UID_JobTask = p.UID_JobTask join JobRunParameter rp on rp.UID_Job = j.UID_Job and rp.UID_JobParameter = p.UID_JobParameter where p.IsPartialCrypted11 = 1 and rp.IsPartialCrypted = 0 and d.IsPartialCrypted = 0 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT12 END CATCH end 13