Back to OIM Explorer

dbo.QBM_PF84975544A6AEABC94405E1_a

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

SQL40 lines
1CREATE PROCEDURE QBM_PF84975544A6AEABC94405E1_a(2  @BlockSize int,3  @ReadyForDeleteOrExport int,4  @KeyPattern varchar(25),5  @Grenzdatum datetime6)7AS8BEGIN9  DECLARE @BlockPuffer QBM_YSingleGUID10  DECLARE @lauf int11  DECLARE @XUser nvarchar(64) = object_name(@@procid)12  DECLARE @Xdate datetime = getutcdate()13  DECLARE @CountRowsToDelete int14  INSERT INTO @BlockPuffer(UID_SingleGuid)15  SELECT TOP(@BlockSize) h.UID_JobHistory16  FROM JobHistory h17    WITH(readpast)18  WHERE19    h.ReadyForDeleteOrExport = 0 AND h.UID_Tree IN(20  SELECT h1.UID_Tree21  FROM jobhistory h122  WHERE23    h1.ReadyForDeleteOrExport = 0 AND h1.GenProcID LIKE @KeyPattern24  GROUP BY h1.uid_tree25  HAVING max(coalesce(h1.EndedAt, h1.StartAt, h1.XDateUpdated)) < @Grenzdatum)26  SELECT @CountRowsToDelete = @@ROWCOUNT27  SELECT @lauf = @CountRowsToDelete - @BlockSize + 128  IF @CountRowsToDelete > 029  BEGIN30    UPDATE JobHistory31    SET ReadyForDeleteOrExport = @ReadyForDeleteOrExport,32    XDateUpdated = @Xdate,33    XUserUpdated = @XUser34    FROM JobHistory h35    JOIN @BlockPuffer p36      ON h.UID_JobHistory = p.UID_SingleGuid37  END38  endLabel:39  RETURN(@lauf)40END
Open raw exported source
SQL ยท Raw8 lines
1     create   procedure QBM_PF84975544A6AEABC94405E1_a( @BlockSize int , @ReadyForDeleteOrExport int , @KeyPattern varchar(25) , @Grenzdatum datetime2 ) as begin declare @BlockPuffer QBM_YSingleGUID declare @lauf int declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate3() declare @CountRowsToDelete int insert into @BlockPuffer(UID_SingleGuid) select top (@BlockSize) h.UID_JobHistory from JobHistory h with (readpast) where4 h.ReadyForDeleteOrExport = 0 and h.UID_Tree in (select h1.UID_Tree from jobhistory h1 where h1.ReadyForDeleteOrExport = 0 and h1.GenProcID like @KeyPattern5 group by h1.uid_tree   having max(coalesce(h1.EndedAt, h1.StartAt, h1.XDateUpdated))< @Grenzdatum ) select @CountRowsToDelete = @@ROWCOUNT select @lauf6 = @CountRowsToDelete - @BlockSize + 1 if @CountRowsToDelete > 0 begin update JobHistory set ReadyForDeleteOrExport = @ReadyForDeleteOrExport , XDateUpdated7 = @Xdate , XUserUpdated = @XUser from JobHistory h join @BlockPuffer p on h.UID_JobHistory = p.UID_SingleGuid end endLabel: return(@lauf) end 8