Back to OIM Explorer

dbo.QBM_ZScheduleStartDashBoard

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QBM-K-CommonDashboard / QBM_ZDashBoardContentCalculate at line 4; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 714 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

  • Bulk DBQueue insert -> QBM-K-CommonDashboard / QBM_ZDashBoardContentCalculate at line 4
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZDashBoardContentCalculate at line 4 Bulk DBQueue insert -> QBM-K-CommonDashboard / QBM_ZDashBoardContentCalculate at line 4
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_ZScheduleStart source text reference
  • queues DBQueue task QBM-K-CommonDashboard -> QBM_ZDashBoardContentCalculate QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboard', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL39 lines
1CREATE PROCEDURE QBM_ZScheduleStartDashBoard(2  @SlotNumber int3)4AS5BEGIN6  SET nocount7    ON8  BEGIN TRY9    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw10    INSERT INTO @DBQueueElements_01(object,11    subobject,12    genprocid)13    SELECT14      x.uid,15      NULL,16      x.GenProcID17    FROM(18    SELECT19      r.uid_DialogDashBoardDef AS uid,20      cu.GenProcID21    FROM DialogDashBoardDef r22    JOIN QBMDBQueueCurrent cu23      WITH(readpast)24      ON r.UID_DialogSchedule = cu.UID_Parameter AND cu.SlotNumber = @SlotNumber25    WHERE26      r.IsInActive = 0 AND r.IsAdHoc = 0 AND r.IsManual = 0) AS x27    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboard',28      @DBQueueElements_0129  END TRY30  BEGIN CATCH31    EXEC QBM_PSessionErrorAdd DEFAULT32    RAISERROR('',33    18,34    1)35      WITH NOWAIT36  END CATCH37  ende:38  RETURN39END
Open raw exported source
SQL ยท Raw6 lines
1   create   procedure QBM_ZScheduleStartDashBoard (@SlotNumber int ) AS begin set nocount on BEGIN TRY  declare @DBQueueElements_01 QBM_YDBQueueRaw2 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select r.uid_DialogDashBoardDef as uid, cu.GenProcID3 from DialogDashBoardDef r join QBMDBQueueCurrent cu with (readpast) on r.UID_DialogSchedule = cu.UID_Parameter and cu.SlotNumber = @SlotNumber  where 4r.IsInActive = 0 and r.IsAdHoc = 0 and r.IsManual = 0 ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboard', @DBQueueElements_01 END TRY BEGIN CATCH5 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: return end 6