dbo.DPR_TIDPRSystemSyncDependency

SQL_TRIGGER parent DPRSystemSyncDependency

Created 2025-06-27T18:01:03.230 · modified 2026-04-14T23:23:08.300 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
No parameters.

Referenced objects

SchemaObjectColumn/minorClass
deletedOBJECT_OR_COLUMN
insertedOBJECT_OR_COLUMN
JobQueueOBJECT_OR_COLUMN
QBM_PJobCreate_HOFireEventOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
dboQBM_FGISessionContextOBJECT_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   trigger DPR_TIDPRSystemSyncDependency on DPRSystemSyncDependency  for insert not for Replication as begin declare @Starten datetime =
2 dateadd(ss, 100, getutcdate()) declare @UID_Job varchar(38) = null declare @GenProcID varchar(38)= dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select
3 top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: select top 1 @UID_Job = q.UID_Job from JobQueue q where
4 q.JobChainName = 'Created by QBMDBQueueProcess: fire event UpdateSystemSyncs for object type DialogDatabase' and q.Ready2EXE = N'TRUE' if @UID_Job > ' '
5  begin  update JobQueue set StartAt = @Starten where UID_Job = @UID_Job end else begin   exec QBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1'
6, 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
7 ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
8

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:23:08.300

creates object-layer jobs via QBM_PJobCreate* fires object-layer event via HOFireEvent uses session context values has TRY/CATCH error handling

Summary: calls QBM_PJobCreate_HOFireEvent, QBM_PSessionErrorAdd; writes INSERT not, UPDATE JobQueue; reads/joins inserted, deleted, JobQueue

Declared parameters

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

DML targets

INSERT not UPDATE JobQueue

Called routines

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: @Starten @UID_Job @GenProcID @ObjectKeysAffected @Startat

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.