Back to OIM Explorer

dbo.QBM_PJobCreate_SendMail

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOFireEvent -> DialogDatabase.SendMail at line 6; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*

Source: sandbox-db sys.sql_modules

Source size: 2.089 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOFireEvent -> DialogDatabase.SendMail at line 6
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*

Typed Edges

  • fires event DialogDatabase.SendMail HOFireEvent -> DialogDatabase.SendMail at line 6
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL90 lines
1CREATE PROCEDURE QBM_PJobCreate_SendMail(2  @Subject nvarchar(255),3  @Message nvarchar(max) = N '',4  @Address nvarchar(1024) = N '',5  @Senderaddress nvarchar(1024) = N '',6  @cc nvarchar(255) = N '',7  @Bcc nvarchar(255) = N '',8  @StartAt datetime = NULL,9  @priority int = 1,10  @Xuserinserted nvarchar(64) = N '',11  @GenProcID varchar(38) = N '',12  @checkForExisting BIT = 0,13  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,14  @AdditionalMessage nvarchar(max) = N '',15  @QueueName nvarchar(256) = NULL16)17AS18BEGIN19  SET XACT_ABORT OFF20  BEGIN TRY21    IF isnull(@Address,22    N '') = N ''23    BEGIN24      SELECT TOP 1 @Address = value25      FROM dialogconfigparm26      WHERE27        fullpath = N 'Common\MailNotification\DefaultAddress'28    END29    IF isnull(@Senderaddress,30    N '') = N ''31    BEGIN32      SELECT TOP 1 @Senderaddress = value33      FROM dialogconfigparm34      WHERE35        fullpath = N 'Common\MailNotification\DefaultSender'36    END37    EXEC QBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase',38      @whereclause = 'IsMainDatabase = 1',39      @EventName = 'SendMail',40      @GenProcID = @GenProcID,41      @ObjectKeysAffected = @AdditionalObjectKeysAffected,42      @p2 = N '_paramName1',43      @v2 = N 'pcSubject',44      @p3 = N '_paramValue1',45      @v3 = @Subject,46      @p4 = N '_paramName2',47      @v4 = N 'pcMessage',48      @p5 = N '_paramValue2',49      @v5 = @Message,50      @p6 = N '_paramName3',51      @v6 = N 'pcAddress',52      @p7 = N '_paramValue3',53      @v7 = @Address,54      @p8 = N '_paramName4',55      @v8 = N 'pcSenderaddress',56      @p9 = N '_paramValue4',57      @v9 = @Senderaddress,58      @p10 = N '_paramName5',59      @v10 = N 'pccc',60      @p11 = N '_paramValue5',61      @v11 = @cc,62      @p12 = N '_paramName6',63      @v12 = N 'pcBcc',64      @p13 = N '_paramValue6',65      @v13 = @Bcc,66      @p14 = N '_paramName7',67      @v14 = N 'pcAttachment',68      @p15 = N '_paramValue7',69      @v15 = N '',70      @p16 = N '_paramName8',71      @v16 = N 'pcAdditionalMessage',72      @p17 = N '_paramValue8',73      @v17 = @AdditionalMessage,74      @Priority = 12,75      @checkForExisting = @checkForExisting,76      @QueueName = @QueueName,77      @StartAt = @StartAt,78      @XUser = @XUserInserted79  END TRY80  BEGIN CATCH81    EXEC QBM_PSessionErrorAdd DEFAULT82    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()83    RAISERROR(@Rethrow,84    18,85    1)86      WITH NOWAIT87  END CATCH88  ende:89  RETURN90END
Open raw exported source
SQL ยท Raw15 lines
1  create   procedure QBM_PJobCreate_SendMail ( @Subject nvarchar(255), @Message nvarchar(max) = N'', @Address nvarchar (1024) = N'', @Senderaddress2 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(max4) = N'' , @QueueName nvarchar(256) = null )as begin SET XACT_ABORT OFF BEGIN TRY if isnull(@Address, N'') = N'' begin select top 1 @Address = value from5 dialogconfigparm where fullpath = N'Common\MailNotification\DefaultAddress' end if isnull(@Senderaddress, N'') = N'' begin select top 1 @Senderaddress6 = 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', @v910 = @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 = @StartAt13 , @XUser = @XUserInserted END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR14 (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 15