Back to OIM Explorer

dbo.QBM_PJobQueueOverviewSetInv

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 677 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL35 lines
1CREATE PROCEDURE QBM_PJobQueueOverviewSetInv(2  @Queues QBM_YDBQueueRaw READONLY3)4AS5BEGIN6  SET XACT_ABORT OFF7  DECLARE @QueuesNeeded QBM_YParameterList8  INSERT INTO @QueuesNeeded(Parameter1)9  SELECT10    DISTINCT q.Object11  FROM @Queues q12  DELETE @QueuesNeeded13  FROM @QueuesNeeded n14  JOIN QBMJobqueueOverview o15    WITH(nolock)16    ON n.Parameter1 = o.UID_QBMJobqueueOverview17  WHERE18    o.IsInvalid = 119  IF EXISTS(20    SELECT TOP 1 121    FROM @QueuesNeeded n)22  BEGIN23    SET lock_timeout 2024    BEGIN TRY25      UPDATE QBMJobqueueOverview26      SET IsInvalid = 127      FROM QBMJobqueueOverview o28      JOIN @QueuesNeeded n29        ON n.Parameter1 = o.UID_QBMJobqueueOverview30    END TRY31    BEGIN CATCH32    END CATCH33    SET lock_timeout -134  END35END
Open raw exported source
SQL ยท Raw6 lines
1 create   procedure QBM_PJobQueueOverviewSetInv  (@Queues QBM_YDBQueueRaw readonly ) as begin SET XACT_ABORT OFF  declare @QueuesNeeded QBM_YParameterList2  insert into @QueuesNeeded (Parameter1) select distinct q.Object from @Queues q delete @QueuesNeeded from @QueuesNeeded n join QBMJobqueueOverview o with3 (nolock) on n.Parameter1 = o.UID_QBMJobqueueOverview where o.IsInvalid = 1 if exists (select top 1 1 from @QueuesNeeded n ) begin set lock_timeout 20 4  BEGIN TRY update QBMJobqueueOverview set IsInvalid = 1 from QBMJobqueueOverview o join @QueuesNeeded n on n.Parameter1 = o.UID_QBMJobqueueOverview END5 TRY BEGIN CATCH  END CATCH set lock_timeout -1 end end 6