dbo.QBM_PJournalShrink

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:29.257 · modified 2026-04-14T23:20:25.943 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
No parameters.

Referenced objects

Schema	Object	Class
	QBM_PDeleteBulk	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
dbo	QBM_FCVStringToInt	OBJECT_OR_COLUMN
dbo	QBM_FGIConfigparmValue	OBJECT_OR_COLUMN
dbo	QBM_FGISessionErrorRethrow	OBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1  create   procedure QBM_PJournalShrink as begin declare @AnzahlTage int declare @AnzahlTageT int declare @AnzahlTageD int declare @AnzahlTageI 
2int declare @AnzahlTageW int declare @AnzahlTageE int declare @BulkCount int declare @TotalCount int declare @Grenze nvarchar(1000) = '' declare @Klausel
3 nvarchar(max) declare @AnzahlGeloescht int declare @AnzahlTotal int = 0 declare @DebugSwitch int = 0 SET XACT_ABORT OFF BEGIN TRY select @BulkCount = 
4dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue( 'Common\Journal\Delete\BulkCount'), 200) select @TotalCount = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue
5( 'Common\Journal\Delete\TotalCount'), 10000) select @AnzahlTage = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue( 'Common\Journal\LifeTime'), 30) select
6 @AnzahlTageE = abs(dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue( 'Common\Journal\LifeTime\E'), @AnzahlTage)) * (-1) select @AnzahlTageW = abs(dbo.QBM_FCVStringToInt
7(dbo.QBM_FGIConfigparmValue( 'Common\Journal\LifeTime\W'), @AnzahlTage)) * (-1) select @AnzahlTageI = abs(dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue
8( 'Common\Journal\LifeTime\I'), @AnzahlTage)) * (-1) select @AnzahlTageD = abs(dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue( 'Common\Journal\LifeTime\D'
9), 3)) * (-1) select @AnzahlTageT = abs(dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue( 'Common\Journal\LifeTime\T'), 1)) * (-1) select @Klausel = concat
10( '( MessageType = ''E'' and  messagedate < ''' , convert(nvarchar(64), dateadd(dd, @AnzahlTageE, GetUTCDate()), 121) + N''' )' , char(13), char(10), 'OR ( MessageType = ''W'' and  messagedate < '''
11 + convert(nvarchar(64), dateadd(dd, @AnzahlTageW, GetUTCDate()), 121) + N''')' , char(13), char(10), 'OR ( MessageType = ''I'' and  messagedate < ''' 
12+ convert(nvarchar(64), dateadd(dd, @AnzahlTageI, GetUTCDate()), 121) + N''')' , char(13), char(10), 'OR ( MessageType = ''D'' and  messagedate < ''' +
13 convert(nvarchar(64), dateadd(dd, @AnzahlTageD, GetUTCDate()), 121) + N''')' , char(13), char(10), 'OR ( MessageType = ''T'' and  messagedate < ''' + 
14convert(nvarchar(64), dateadd(dd, @AnzahlTageT, GetUTCDate()), 121) + N''')' )  if @DebugSwitch > 0 begin print @Klausel end exec @AnzahlGeloescht = QBM_PDeleteBulk
15 'DialogJournal', @Klausel, @BulkCount, @TotalCount select @AnzahlTotal += @AnzahlGeloescht END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare
16 @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return (@AnzahlTotal) end 
17

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:25.943

has TRY/CATCH error handling

Summary: calls QBM_PDeleteBulk, QBM_PSessionErrorAdd; uses config Common\Journal\Delete\BulkCount, Common\Journal\Delete\TotalCount, Common\Journal\LifeTime…

Declared parameters

No declared parameters in sys.parameters for this object, or metadata was not available.

DML targets

None extracted.

Called routines

Read/join references

None extracted.

SQL dependency metadata

Config/session

Config: Common\Journal\Delete\BulkCount Common\Journal\Delete\TotalCount Common\Journal\LifeTime Common\Journal\LifeTime\E Common\Journal\LifeTime\W Common\Journal\LifeTime\I Common\Journal\LifeTime\D Common\Journal\LifeTime\T

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @AnzahlTage @AnzahlTageT @AnzahlTageD @AnzahlTageI @AnzahlTageW @AnzahlTageE @BulkCount @TotalCount @Grenze @Klausel @AnzahlGeloescht @AnzahlTotal @DebugSwitch @Rethrow

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

Referencing object	Relation	Evidence
dbo.QBM_PWorkHistoryDelete	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PWorkHistoryDelete	source text reference	uses session context values, has TRY/CATCH error handling