dbo.QBM_FTJobCreateDBParameter
SQL_INLINE_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:20:31.167 · modified 2026-04-14T23:20:31.167 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@ComponentClass | nvarchar | no |
@TaskName | nvarchar | no |
@ParameterSoFar | QBM_YParameterList | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | DialogDatabase | OBJECT_OR_COLUMN | |
| dbo | DialogDatabase | IsMainDatabase | OBJECT_OR_COLUMN |
| dbo | DialogDatabase | ConnectionProvider | OBJECT_OR_COLUMN |
| dbo | DialogDatabase | ConnectionString | OBJECT_OR_COLUMN |
| dbo | JobComponent | OBJECT_OR_COLUMN | |
| dbo | JobComponent | UID_JobComponent | OBJECT_OR_COLUMN |
| dbo | JobComponent | ComponentClass | OBJECT_OR_COLUMN |
| dbo | JobParameter | OBJECT_OR_COLUMN | |
| dbo | JobParameter | UID_JobTask | OBJECT_OR_COLUMN |
| dbo | JobParameter | Name | OBJECT_OR_COLUMN |
| dbo | JobTask | OBJECT_OR_COLUMN | |
| dbo | JobTask | UID_JobTask | OBJECT_OR_COLUMN |
| dbo | JobTask | UID_JobComponent | OBJECT_OR_COLUMN |
| dbo | JobTask | TaskName | OBJECT_OR_COLUMN |
| dbo | QBM_YParameterList | TYPE |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1create function dbo.QBM_FTJobCreateDBParameter(@ComponentClass nvarchar(1024) , @TaskName nvarchar(256) , @ParameterSoFar dbo.QBM_YParameterList readOnly 2 ) returns table with schemabinding as return ( select 'ConnectionProvider' as ParameterName , d.ConnectionProvider as ParameterValue from dbo.DialogDatabase 3 d with (nolock) where IsMainDatabase = 1 and exists (select top 1 1 from dbo.JobComponent c join dbo.JobTask t on c.UID_JobComponent = t.UID_JobComponent 4 join dbo.JobParameter p on p.UID_JobTask = t.UID_JobTask where c.ComponentClass = @ComponentClass and t.TaskName = @TaskName and p.Name = 'ConnectionProvider' 5 ) and Not exists (select top 1 1 from @ParameterSoFar f where f.Parameter1 = 'ConnectionProvider' ) union all select 'ConnectionString' , d.ConnectionString 6 from dbo.DialogDatabase d with (nolock) where IsMainDatabase = 1 and exists (select top 1 1 from dbo.JobComponent c join dbo.JobTask t on c.UID_JobComponent 7 = t.UID_JobComponent join dbo.JobParameter p on p.UID_JobTask = t.UID_JobTask where c.ComponentClass = @ComponentClass and t.TaskName = @TaskName and 8p.Name = 'ConnectionString' ) and Not exists (select top 1 1 from @ParameterSoFar f where f.Parameter1 = 'ConnectionString' ) ) 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.167
None extracted.
Summary: reads/joins DialogDatabase, JobComponent, JobTask, JobParameter
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@ComponentClass | nvarchar(1024) | input |
@TaskName | nvarchar(256) | input |
@ParameterSoFar | qbm_yparameterlist | 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: @ComponentClass @TaskName @ParameterSoFar
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_PJobCreate | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PJobCreate | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |