Source: projects/identity-management/oim-kb-update/sandbox-db/2026-04-27-pjobcreate-method-event-evidence.md

> Source: projects/identity-management/oim-kb-update/sandbox-db/2026-04-27-pjobcreate-method-event-evidence.md

Sandbox DB Evidence - QBM_PJobCreate Methods and Events

Scope: SELECT-only metadata inspection in live sandbox OneIM DB on im.sandbox.local.

Procedure Interfaces

QBM_PJobCreate_HOCallMethod, _B, and _L accept:

• target object selection: @objecttype plus @whereclause or @XObjectKeys
• method: @MethodName
• save behavior: @save
• correlation: @GenProcID, affected object-key list, basis object key
• payload: @param1 ... @param10

QBM_PJobCreate_HOFireEvent, _B, and _L accept:

• target object selection: @objecttype plus @whereclause or @XObjectKeys
• event: @EventName
• correlation: @GenProcID, affected object-key list, basis object key
• payload: @p2/@v2 ... @p31/@v31

Parameter-count summary:

Metadata Tables

Catalog counts in this sandbox:

Relevant table roles:

• DialogMethod: UI/dialog-method definitions (MethodName, MethodScript, Caption, MethodEnabledFor, IsDeactivated, MethodBehavior).
• DialogObjectHasMethod: assignment of a dialog method to a dialog object.
• DialogObject: object definitions with ObjectName, UID_DialogTable, and optional WhereClause.
• QBMEvent: event definitions per DialogTable (EventName, UID_DialogTable).
• JobEventGen: maps QBMEvent rows to process generation entries.
• JobChain: process metadata, including preprocessor/deactivation state.

Dialog Methods Assigned to Objects

Examples from DialogMethod joined to DialogObjectHasMethod / DialogObject / DialogTable:

Important observation: the object-layer methods used by shipped SQL are not limited to DialogMethod. A direct query for Abort, MakeDecision, PrepareAttestations, and related shipped SQL method names returned no DialogMethod rows. Those are object-layer/customizer methods invoked by job creation.

Literal Method Names Used by Shipped SQL

Extracted from SQL modules containing QBM_PJobCreate_HOCallMethod*:

Events Available Through QBMEvent

Events are table-scoped: use (DialogTable.TableName, QBMEvent.EventName), not just the event string.

Examples from QBMEvent / JobEventGen:

Literal Event Names Used by Shipped SQL

Extracted from SQL modules containing QBM_PJobCreate_HOFireEvent*:

Practical Lookup Queries

Find UI/dialog methods for a table:

SELECT dm.MethodName, dm.Caption, dt.TableName, dob.ObjectName, dm.MethodBehavior, dm.MethodEnabledFor
FROM DialogMethod dm
JOIN DialogObjectHasMethod dohm ON dohm.UID_DialogMethod = dm.UID_DialogMethod
JOIN DialogObject dob ON dob.UID_DialogObject = dohm.UID_DialogObject
JOIN DialogTable dt ON dt.UID_DialogTable = dob.UID_DialogTable
WHERE dt.TableName = N'ITShopOrg'
ORDER BY dm.MethodName, dob.ObjectName;

Find events and generated processes for a table:

SELECT qe.EventName, dt.TableName, jc.Name AS ProcessName, jeg.OrderNr,
       jc.NoGenerate, jc.IsDeactivatedByPreProcessor
FROM QBMEvent qe
JOIN DialogTable dt ON dt.UID_DialogTable = qe.UID_DialogTable
LEFT JOIN JobEventGen jeg ON jeg.UID_QBMEvent = qe.UID_QBMEvent
LEFT JOIN JobChain jc ON jc.UID_JobChain = jeg.UID_JobChain
WHERE dt.TableName = N'PersonWantsOrg'
ORDER BY qe.EventName, jeg.OrderNr;

Find shipped SQL that calls methods/events:

SELECT OBJECT_NAME(m.object_id) AS ObjectName, o.type_desc
FROM sys.sql_modules m
JOIN sys.objects o ON o.object_id = m.object_id
WHERE m.definition LIKE '%QBM_PJobCreate_HOCallMethod%'
   OR m.definition LIKE '%QBM_PJobCreate_HOFireEvent%'
ORDER BY o.type_desc, ObjectName;

Interpretation

• For HOCallMethod, there are two lookup classes:
• UI/dialog methods: query DialogMethod assignments.
• Object-layer/customizer methods: infer from shipped SQL, MDK/source documentation, or object-layer code; they may not appear in DialogMethod.
• For HOFireEvent, use QBMEvent as the event catalog and JobEventGen/JobChain as the process-generation map.
• A method/event being technically fireable does not mean it is safe. The selection clause/object list, GenProcID, BasisObjectKey, freeze-on-error behavior, and duplicate-check behavior matter.