Back to OIM Explorer

dbo.QBM_ZScheduleStartTask

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. bulk DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 5; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 869 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-CommonReCalculate / QBM_ZRecalculate at line 5
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZRecalculate at line 5 bulk DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 5
  • 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-CommonReCalculate -> QBM_ZRecalculate QBM_PDBQueueInsert_bulk 'QBM-K-CommonReCalculate', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL48 lines
1CREATE PROCEDURE QBM_ZScheduleStartTask(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent7  BEGIN TRY8    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,9    UID_Parameter,10    UID_SubParameter,11    GenProcID)12    SELECT13      UID_DialogDBQueue,14      UID_Parameter,15      UID_SubParameter,16      GenProcID17    FROM QBMDBQueueCurrent cu18      WITH(readpast)19    WHERE20      cu.SlotNumber = @SlotNumber21    IF @@rowcount = 022    BEGIN23      GOTO EndLabel24    END25    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw26    INSERT INTO @DBQueueElements_01(Object,27    SubObject,28    GenProcID)29    SELECT30      ja.UID_Task,31      NULL,32      cu.GenProcID33    FROM QBMDBQueueTaskHasSchedule ja34    JOIN @DBQueueCurrent cu35      ON ja.UID_DialogSchedule = cu.UID_Parameter36    EXEC QBM_PDBQueueInsert_bulk 'QBM-K-CommonReCalculate',37      @DBQueueElements_0138  END TRY39  BEGIN CATCH40    EXEC QBM_PSessionErrorAdd DEFAULT41    RAISERROR('',42    18,43    1)44      WITH NOWAIT45  END CATCH46  endLabel:47  RETURN48END
Open raw exported source
SQL ยท Raw7 lines
1   create   procedure QBM_ZScheduleStartTask (@SlotNumber int ) AS begin declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent2(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent3 cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into4 @DBQueueElements_01 (Object, SubObject, GenProcID) select ja.UID_Task, null, cu.GenProcID from QBMDBQueueTaskHasSchedule ja join @DBQueueCurrent cu on5 ja.UID_DialogSchedule = cu.UID_Parameter  exec QBM_PDBQueueInsert_bulk 'QBM-K-CommonReCalculate', @DBQueueElements_01       END TRY BEGIN CATCH exec QBM_PSessionErrorAdd6 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: return end 7