dbo.QBM_TUJobParameter

1  create   trigger QBM_TUJobParameter on JobParameter  for Update not for Replication as begin declare @XUser nvarchar(64) = object_name(@@procid
2) 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 start
3 return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(IsCrypted) begin update JobRunParameter set IsCrypted
4 = 1 , XDateUpdated = @Xdate , XUserUpdated = @XUser  from JobParameter p join deleted d on p.UID_JobParameter = d.UID_JobParameter  join Job j on j.UID_JobTask
5 = 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 JobParameter
7 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_Job
8 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_JobParameter
10  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.IsPartialCrypted
11 = 1 and rp.IsPartialCrypted = 0 and d.IsPartialCrypted = 0 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT
12 END CATCH end 
13