dbo.QBM_FGIJobQueueExistsPending
SQL_SCALAR_FUNCTION
Created 2025-06-27T18:00:59.710 · modified 2026-04-14T23:20:31.100 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| bit | yes |
@XObjectKey | varchar | no |
@ParamInPattern | nvarchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | JobQueue | OBJECT_OR_COLUMN | |
| dbo | JobQueue | UID_Job | OBJECT_OR_COLUMN |
| dbo | JobQueue | UID_Tree | OBJECT_OR_COLUMN |
| dbo | JobQueue | ParamIN | OBJECT_OR_COLUMN |
| dbo | JobQueue | Ready2EXE | OBJECT_OR_COLUMN |
| dbo | QBMElementAffectedByJob | OBJECT_OR_COLUMN | |
| dbo | QBMElementAffectedByJob | UID_Job | OBJECT_OR_COLUMN |
| dbo | QBMElementAffectedByJob | ObjectKeyAffected | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create function dbo.QBM_FGIJobQueueExistsPending ( @XObjectKey varchar(138) , @ParamInPattern nvarchar(1000) ) returns bit with schemabinding 2 as begin declare @PIPattern nvarchar(1000) DECLARE @pendingProcessFound BIT = 0 select @PIPattern = @ParamInPattern if ISNULL(@PIPattern, N'') = N'' 3begin return(@pendingProcessFound) end if LEFT(@PIPattern, 1) <> N'%' begin select @PIPattern = N'%' + @PIPattern end if right(@PIPattern, 1) <> N'%' 4 begin select @PIPattern = @PIPattern + N'%' end IF EXISTS ( select top 1 1 FROM ( SELECT UID_Tree FROM dbo.JobQueue q with (nolock) join dbo.QBMElementAffectedByJob 5 ebj on q.UID_Job = ebj.UID_Job WHERE ebj.ObjectKeyAffected = @XObjectKey AND q.ParamIN like @PIPattern GROUP BY q.UID_Tree ) AS x join (select q2.UID_Tree 6 , SUM(CASE q2.Ready2EXE WHEN N'TRUE' THEN 1 WHEN N'FALSE' THEN 1 ELSE 0 END) AS CountNotRunning ,COUNT(*) AS CountAll from dbo.JobQueue q2 with (nolock 7) group by q2.UID_Tree ) as y on x.UID_Tree = y.UID_Tree WHERE y.CountNotRunning = y.CountAll ) BEGIN SELECT @pendingProcessFound = 1 END endLabel: RETURN 8 (@pendingProcessFound) end 9
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:31.100
None extracted.
Summary: reads/joins JobQueue, QBMElementAffectedByJob
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| bit | OUTPUT |
@XObjectKey | varchar(138) | input |
@ParamInPattern | nvarchar(1000) | input |
DML targets
None extracted.Called routines
None extracted.
Read/join references
SQL dependency metadata
Config/session
Config: None extracted.
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @XObjectKey @ParamInPattern @PIPattern @pendingProcessFound
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.
No reverse dependencies extracted.