dbo.QBM_TDJobqueue

1  create   trigger QBM_TDJobqueue on JobQueue  for delete not for Replication as begin   declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
2('') 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_01
4 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 join
6 QBMJobqueueOverview o with (readpast) on q.Object = o.UID_QBMJobqueueOverview where o.IsInvalid = 1 if exists (select top 1 1 from @DBQueueElements_01
7 ) begin   exec QBM_PJobQueueOverviewSetInv @DBQueueElements_01 end    delete QBMElementAffectedByJob from @DeletedElements d join QBMElementAffectedByJob
8 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