dbo.QBM_PJobCreate_SendMail
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:00.147 · modified 2026-04-14T23:20:31.630 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@Subject | nvarchar | no |
@Message | nvarchar | no |
@Address | nvarchar | no |
@Senderaddress | nvarchar | no |
@cc | nvarchar | no |
@Bcc | nvarchar | no |
@StartAt | datetime | no |
@priority | int | no |
@Xuserinserted | nvarchar | no |
@GenProcID | varchar | no |
@checkForExisting | bit | no |
@AdditionalObjectKeysAffected | QBM_YParameterList | no |
@AdditionalMessage | nvarchar | no |
@QueueName | nvarchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dialogconfigparm | OBJECT_OR_COLUMN | ||
| QBM_PJobCreate_HOFireEvent | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YParameterList | TYPE | ||
| dbo | QBM_FGISessionErrorRethrow | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create procedure QBM_PJobCreate_SendMail ( @Subject nvarchar(255), @Message nvarchar(max) = N'', @Address nvarchar (1024) = N'', @Senderaddress 2 nvarchar(1024) = N'', @cc nvarchar(255) = N'', @Bcc nvarchar(255) = N'', @StartAt datetime = NULL , @priority int = 1, @Xuserinserted nvarchar(64) = N'' 3, @GenProcID varchar(38) = N'', @checkForExisting bit = 0 , @AdditionalObjectKeysAffected QBM_YParameterList readonly ,@AdditionalMessage nvarchar(max 4) = N'' , @QueueName nvarchar(256) = null )as begin SET XACT_ABORT OFF BEGIN TRY if isnull(@Address, N'') = N'' begin select top 1 @Address = value from 5 dialogconfigparm where fullpath = N'Common\MailNotification\DefaultAddress' end if isnull(@Senderaddress, N'') = N'' begin select top 1 @Senderaddress 6 = value from dialogconfigparm where fullpath = N'Common\MailNotification\DefaultSender' end exec QBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase' 7, @whereclause = 'IsMainDatabase = 1', @EventName = 'SendMail', @GenProcID = @GenProcID, @ObjectKeysAffected = @AdditionalObjectKeysAffected, @p2 = N'_paramName1' 8, @v2 = N'pcSubject', @p3 = N'_paramValue1', @v3 = @Subject, @p4 = N'_paramName2', @v4 = N'pcMessage' , @p5 = N'_paramValue2' , @v5 = @Message , @p6 = 9N'_paramName3', @v6 = N'pcAddress' , @p7 = N'_paramValue3', @v7 = @Address , @p8 = N'_paramName4', @v8 = N'pcSenderaddress' , @p9 = N'_paramValue4', @v9 10 = @Senderaddress , @p10 = N'_paramName5', @v10 = N'pccc' , @p11 = N'_paramValue5', @v11 = @cc , @p12 = N'_paramName6', @v12 = N'pcBcc' , @p13 = N'_paramValue6' 11, @v13 = @Bcc , @p14 = N'_paramName7', @v14 = N'pcAttachment' , @p15 = N'_paramValue7', @v15 = N'' , @p16 = N'_paramName8', @v16 = N'pcAdditionalMessage' 12 , @p17 = N'_paramValue8', @v17 = @AdditionalMessage, @Priority = 12 , @checkForExisting = @checkForExisting , @QueueName = @QueueName , @StartAt = @StartAt 13 , @XUser = @XUserInserted END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR 14 (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 15
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.630
creates object-layer jobs via QBM_PJobCreate* fires object-layer event via HOFireEvent has TRY/CATCH error handling
Summary: calls QBM_PJobCreate_HOFireEvent, QBM_PSessionErrorAdd; reads/joins dialogconfigparm; uses config Common\MailNotification\DefaultAddress, Common\MailNotification\DefaultSender
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@Subject | nvarchar(255) | input |
@Message | nvarchar | input |
@Address | nvarchar(1024) | input |
@Senderaddress | nvarchar(1024) | input |
@cc | nvarchar(255) | input |
@Bcc | nvarchar(255) | input |
@StartAt | datetime | input |
@priority | int | input |
@Xuserinserted | nvarchar(64) | input |
@GenProcID | varchar(38) | input |
@checkForExisting | bit | input |
@AdditionalObjectKeysAffected | qbm_yparameterlist | input |
@AdditionalMessage | nvarchar | input |
@QueueName | nvarchar(256) | input |
DML targets
None extracted.Called routines
Read/join references
SQL dependency metadata
Config/session
Config: Common\MailNotification\DefaultAddress Common\MailNotification\DefaultSender
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @Subject @Message @Address @Senderaddress @cc @Bcc @StartAt @priority @Xuserinserted @GenProcID @checkForExisting @AdditionalObjectKeysAffected @AdditionalMessage @QueueName @objecttype @whereclause @EventName @ObjectKeysAffected @p2 @v2 @p3 @v3 @p4 @v4 @p5 @v5 @p6 @v6 @p7 @v7 @p8 @v8 @p9 @v9 @p10 @v10 @p11 @v11 @p12 @v12
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_PJobUpdateState_Bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropTable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobUpdateState_Bulk | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropTable | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |