dbo.QBM_TUJobqueue

1create   trigger QBM_TUJobqueue on JobQueue  for update not for Replication as begin declare @QueuesToNotify QBM_YParameterList declare @Debugswitch
2 int = 0 declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select
3 top 1 1 from deleted) goto start return start:  if update(Ready2EXE) begin if @Debugswitch > 0 begin print 'Ready2EXE change detected' end         declare
4 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select dbo.QBM_FCVStringToGUID('', x.QueueName), null
5, @GenProcID from ( select distinct a.Queue as QueueName  from deleted a join JobQueue n on a.UID_Job = n.UID_Job where a.Ready2EXE <> n.Ready2EXE and 
6n.Ready2EXE = N'TRUE' ) as x  delete  @DBQueueElements_01 from @DBQueueElements_01 q join QBMJobqueueOverview o with (readpast) on q.Object = o.UID_QBMJobqueueOverview
7 where o.IsInvalid = 1 if exists (select top 1 1 from @DBQueueElements_01 ) begin   exec QBM_PJobQueueOverviewSetInv @DBQueueElements_01 end  end  if update
8(ParamIN) begin if exists (select top 1 1 from deleted d join Jobqueue q on d.UID_Job = q.uid_job where  isnull(d.ParamIN, N'') <> isnull(q.ParamIN, N''
9) and d.ParamIN > ' '  ) begin raiserror( '#LDS#Invalid changes of properties in jobqueue.|', 18, 2) with nowait end end if update(UID_Tree) or (update
10(Queue)  ) or update(ComponentClass) or update(ExecutionType) or update(ComponentAssembly) or update(TaskName) or update(UID_JobError) or update(UID_JobSuccess
11) begin if exists (select top 1 1 from deleted d join Jobqueue q on d.UID_Job = q.uid_job where d.UID_Tree <> q.UID_Tree or isnull(d.Queue, N'') <> isnull
12(q.Queue, N'') or isnull(d.ComponentClass, N'') <> isnull(q.ComponentClass, N'') or isnull(d.ExecutionType, N'') <> isnull(q.ExecutionType, N'') or isnull
13(d.ComponentAssembly, N'') <> isnull(q.ComponentAssembly, N'') or isnull(d.TaskName, N'') <> isnull(q.TaskName, N'') or isnull(d.UID_JobError, '') <> isnull
14(q.UID_JobError, '') or isnull(d.UID_JobSuccess, '') <> isnull(q.UID_JobSuccess, '') ) begin raiserror( '#LDS#Invalid changes of properties in jobqueue.|'
15, 18, 2) with nowait end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
16