OIM KB Update Run - DBQueue Insert and QBM_PJobCreate

Scope

User request: add QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, and QBM_PJobCreate* to the research list / "Open Questions / Next Experiments"; extract relevant knowledge from local EEP/PDF sources; reconcile old negative-slot material with OneIM 9.3+ and V10 vendor documentation; update memory/index data.

Sources Used

Local source files:

C:\Users\vikto\Downloads\EEP - OneIM Security Features.pptx
C:\Users\vikto\Downloads\One Identity Manager - Employee Empowerment Program (India) - Database Calculations and Processing 1.pptx
C:\Users\vikto\Downloads\KNOWLEDGE-1IM - QBM_PJobCreate or how to interact with object layer from SQL-270426-060950.pdf

Vendor sources:

One Identity Manager 9.3 Release Notes: https://support-public.cfm.quest.com/77417_OneIM_ReleaseNotes.pdf
One Identity Manager 10.0 Release Notes: https://support-public.cfm.quest.com/82130_one-identity-manager_release-notes_10.0.pdf
One Identity Manager 10.0 Configuration Guide: https://support-public.cfm.quest.com/82072_one-identity-manager_configuration_10.0.pdf

Live sandbox DB:

SELECT-only inspection against OneIM sandbox on 2026-04-27.
No DML, no schema changes, no DBQueue tasks manually inserted.

Main Findings

QBM_PDBQueueInsert_Single and QBM_PDBQueueInsert_Bulk are the relevant supported SQL-side entry points for enqueueing DBQueue work; the training deck confirms they are used heavily by shipped triggers/procs/functions.
The current sandbox has many shipped references:
Stored procedures: 209 modules hit one of the tracked names; 55 call Single, 97 call Bulk, 83 call QBM_PJobCreate*.
Triggers: 918 modules hit one of the tracked names; 375 call Single, 524 call Bulk, 80 call QBM_PJobCreate*.
The QBM_PJobCreate* family is the DB-to-object-layer bridge: it creates Job queue work when SQL logic needs object-layer behavior such as templates, events, methods, save logic, or process generation.
The older EEP slot-control slides are not reliable for V10 as-is. OneIM 9.3 release notes describe the Database Agent Service as fundamentally revised, with process control moved into the .NET Database Agent Service and several old tables/configuration parameters removed or changed.
For OneIM 10, use the 10.0 Configuration Guide negative QBMDBQueueCurrent.SlotNumber list as the current reference. It includes more deferral/error values than the older slide summary.

Files Updated

projects/identity-management/knowledge-base/oim-dbqueue-and-object-layer-jobs.md
projects/identity-management/oim-kb-update/sandbox-db/2026-04-27-dbqueue-pjobcreate-procedure-evidence.md
projects/identity-management/oim-kb-update/README.md
projects/identity-management/knowledge-base/index.md
projects/identity-management/knowledge-base/oim-it-shop-structure-and-availability.md
resources/links.md
resources/glossary.md

Added Open Questions / Next Experiments

Trace shipped OneIM 10 trigger/procedure choices between QBM_PDBQueueInsert_Single and QBM_PDBQueueInsert_Bulk, especially for ShoppingRack and IT Shop publish/update flows.
Identify which QBM_PJobCreate* calls are involved in QER_PITShopProductNodeCreate_b / ShoppingRack processing and what object-layer operations they delegate.
Resolve why the documented QBM\DBQueue\MaxSlotsPerTask setting did not appear in the current sandbox DialogConfigParm snapshot.
Observe which negative QBMDBQueueCurrent.SlotNumber values occur during controlled AD sync, IT Shop publish, and ShoppingRack refresh tests in the OneIM 10 sandbox.