dbo.QBM_PWaitForSeconds

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

NameTypeOutput
@SecondsToWaitfloatno

Referenced objects

SchemaObjectColumn/minorClass
QBM_PSessionErrorAddOBJECT_OR_COLUMN
dboQBM_FCVIntToStringOBJECT_OR_COLUMN
dboQBM_FCVStringPadLeftOBJECT_OR_COLUMN
dboQBM_FGISessionErrorRethrowOBJECT_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_PWaitForSeconds (@SecondsToWait float )  as begin SET XACT_ABORT OFF BEGIN TRY declare @SQLcmd nvarchar(1024) declare 
2@Timestring varchar(64) declare @SecondsToWait_intern float declare @hours int  declare @Minutes int  declare @Seconds int  declare @MilliSeconds int  
3select @SecondsToWait_intern = case when @SecondsToWait > 7200.0 then 7200.0 when isnull(@SecondsToWait, 0.0) < 0.005 then 0.005 else @SecondsToWait end
4 select @hours = convert(int, @SecondsToWait_intern) / 3600 select @SecondsToWait_intern -= convert(float, @hours) * 3600.0 select @Minutes = convert(int
5, @SecondsToWait_intern ) / 60 select @SecondsToWait_intern -= convert(float, @Minutes * 60) select @Seconds = convert(int, @SecondsToWait_intern ) select
6 @SecondsToWait_intern -= convert(float, @Seconds)  select @MilliSeconds = round(@SecondsToWait_intern*1000.0, 0)  select @Timestring = dbo.QBM_FCVStringPadLeft
7( dbo.QBM_FCVIntToString(@hours), 2, '0') + ':' + dbo.QBM_FCVStringPadLeft( dbo.QBM_FCVIntToString(@Minutes), 2, '0') + ':' + dbo.QBM_FCVStringPadLeft(
8 dbo.QBM_FCVIntToString(@Seconds), 2, '0') + '.' + dbo.QBM_FCVStringPadLeft( dbo.QBM_FCVIntToString(@MilliSeconds), 3, '0')  waitfor delay @timestring 
9END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH
10 NOWAIT END CATCH end 
11

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:14:10.623

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd

Declared parameters

ParameterTypeDirection
@SecondsToWaitfloatinput

DML targets

None extracted.

Called routines

Read/join references

None extracted.

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @SecondsToWait @SQLcmd @Timestring @SecondsToWait_intern @hours @Minutes @Seconds @MilliSeconds @timestring @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 objectRelationEvidence
dbo.QBM_PColumnCustomRemoveSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_CurrentMoveSlotSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_CurrentRestoreSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotRunnerSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueReplGenProcIDSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDialogDBQueueDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PExecuteSQLWithRetry_LLPSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobQueueDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobQueueInitSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMigrationNotReadyForCompSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PQBMDBQueueCurrentDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PQBMDBQueuePondDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PScheduleCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PSlotResetOnMissingItem_LSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkDBQueueDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkHistoryDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkJobQueueDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_P98F5E10C6A9349A1EBFB2C2_SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PPersonDelete_GDPRSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PSlotResetOnInvalidRoot_LSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopHelperFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PColumnCustomRemovesource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_CurrentMoveSlotsource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_CurrentRestoresource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotRunnersource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQueueReplGenProcIDsource text referencehas TRY/CATCH error handling
dbo.QBM_PDialogDBQueueDeletesource text referencehas TRY/CATCH error handling
dbo.QBM_PExecuteSQLWithRetry_LLPsource text referencehas TRY/CATCH error handling
dbo.QBM_PJobQueueDeletesource text referencehas TRY/CATCH error handling
dbo.QBM_PJobQueueInitsource text referencehas TRY/CATCH error handling
dbo.QBM_PMigrationNotReadyForCompsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PQBMDBQueueCurrentDeletesource text referencehas TRY/CATCH error handling
dbo.QBM_PQBMDBQueuePondDeletesource text referencehas TRY/CATCH error handling
dbo.QBM_PScheduleChecksource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PSlotResetOnMissingItem_Lsource text referencehas TRY/CATCH error handling
dbo.QBM_PWorkDBQueueDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkHistoryDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkJobQueueDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_P98F5E10C6A9349A1EBFB2C2_source text referencehas TRY/CATCH error handling
dbo.QER_PPersonDelete_GDPRsource text referencecreates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling
dbo.QER_PSlotResetOnInvalidRoot_Lsource text referencehas TRY/CATCH error handling
dbo.QER_ZITShopHelperFillsource text referencehas TRY/CATCH error handling