Back to OIM Explorer

dbo.QBM_PWatchDogPrepare

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-GetServerProperties / QBM_ZGetServerProperties at line 7; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 1.445 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Single DBQueue insert -> QBM-K-GetServerProperties / QBM_ZGetServerProperties at line 7
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZGetServerProperties at line 7 Single DBQueue insert -> QBM-K-GetServerProperties / QBM_ZGetServerProperties at line 7
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionContextSet source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-GetServerProperties -> QBM_ZGetServerProperties QBM_PDBQueueInsert_Single 'QBM-K-GetServerProperties', '', '', @GenProcID end goto ende end if @DeActivate = 1 begin update DialogDatabase set UpdatePhase = 1 where IsMainDatabase = 1 and UpdatePhase = 0 end END TRY BEGIN CATCH exec QBM_PS…

References

Referenced By

Complete Source

SQL66 lines
1CREATE PROCEDURE QBM_PWatchDogPrepare(2  @DeActivate BIT = 03)4AS5BEGIN6  DECLARE @AgentName nvarchar(256)7  DECLARE @sqlcmd nvarchar(max)8  DECLARE @DebugStarttime datetime = getutcdate()9  DECLARE @DebugLevel char(1) = 'I'10  DECLARE @Message nvarchar(1000)11  DECLARE @AgentNameFull nvarchar(256)12  DECLARE @GenprocID varchar(38) = newid()13  DECLARE @XUser nvarchar(64) = object_name(@@procid)14  DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')15  DECLARE @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser')16  SET XACT_ABORT OFF17  BEGIN TRY18    EXEC QBM_PSessionContextSet 'XUser',19      @XUser20    IF @DeActivate = 021    BEGIN22      IF(23        SELECT24          isnull(max(c.XDateUpdated), '1899-12-31')25      FROM DialogConfigParm c26      WHERE27        c.FullPath LIKE 'QBM\DBServerProperties\%') <(28      SELECT b.create_date29      FROM sys.databases b30      WHERE31        b.name = 'tempdb') AND EXISTS(32      SELECT TOP 1 133      FROM QBMDBQueueTask t34      WHERE35        t.UID_Task = 'QBM-K-GetServerProperties')36      BEGIN37        EXEC QBM_PDBQueueInsert_Single 'QBM-K-GetServerProperties',38        '',39        '',40          @GenProcID41      END42      GOTO ende43    END44    IF @DeActivate = 145    BEGIN46      UPDATE DialogDatabase47      SET UpdatePhase = 148      WHERE49        IsMainDatabase = 1 AND UpdatePhase = 050    END51  END TRY52  BEGIN CATCH53    EXEC QBM_PSessionErrorAdd DEFAULT54    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()55    RAISERROR(@Rethrow,56    18,57    1)58      WITH NOWAIT59  END CATCH60  ende:61  EXEC QBM_PSessionContextSet 'GenProcID',62    @GenProcID_R63  EXEC QBM_PSessionContextSet 'XUser',64    @XUser_R65  RETURN66END
Open raw exported source
SQL · Raw11 lines
1    create   procedure QBM_PWatchDogPrepare (@DeActivate bit = 0 ) as begin declare @AgentName nvarchar(256) declare @sqlcmd nvarchar(max) declare2 @DebugStarttime datetime = getutcdate() declare @DebugLevel char(1) = 'I' declare @Message nvarchar(1000) declare @AgentNameFull nvarchar(256) declare3 @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 @DeActivate5 = 0 begin    if (select isnull(max(c.XDateUpdated), '1899-12-31') from DialogConfigParm c where c.FullPath like 'QBM\DBServerProperties\%' ) < (select6 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 DialogDatabase8 set UpdatePhase = 1  where IsMainDatabase = 1 and UpdatePhase = 0  end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(10009) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R exec10 QBM_PSessionContextSet 'XUser', @XUser_R return end  11