dbo.QBM_PWatchDogPrepare

1    create   procedure QBM_PWatchDogPrepare (@DeActivate bit = 0 ) as begin declare @AgentName nvarchar(256) declare @sqlcmd nvarchar(max) declare
2 @DebugStarttime datetime = getutcdate() declare @DebugLevel char(1) = 'I' declare @Message nvarchar(1000) declare @AgentNameFull nvarchar(256) declare
3 @GenprocID varchar(38) = newid() declare @XUser nvarchar(64) = object_name(@@procid) declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') 
4declare @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser') SET XACT_ABORT OFF BEGIN TRY exec QBM_PSessionContextSet 'XUser', @XUser if @DeActivate
5 = 0 begin    if (select isnull(max(c.XDateUpdated), '1899-12-31') from DialogConfigParm c where c.FullPath like 'QBM\DBServerProperties\%' ) < (select
6 b.create_date from sys.databases b where b.name = 'tempdb' ) and exists (select top 1 1  from QBMDBQueueTask t where t.UID_Task = 'QBM-K-GetServerProperties'
7 ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-GetServerProperties', '', '', @GenProcID end  goto ende  end if @DeActivate = 1 begin update DialogDatabase
8 set UpdatePhase = 1  where IsMainDatabase = 1 and UpdatePhase = 0  end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000
9) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R exec
10 QBM_PSessionContextSet 'XUser', @XUser_R return end  
11