Fire test email reminder for attestation

Hi All,

Does anyone know how to send I can send a test for a reminder email? We are trying to determine somethings with the email routing and need to send some test messages on the fly. I just have a template I want to send as a test but not sure how.

I created a process automation with the event: REMINDER - AttestationHelper and put a Attestation UID_AttestationHelper as a condition but i get an error. You are not allowed to generate events for table AttestationHelper.

Any help is appreciated.

Thank you,

Lu

  • Hi Lu,

    You could try firing this stored proc:

    PROCEDURE [dbo].[QBM_PJobCreate_SendRMail] (

           @uid_DialogRichMail VARCHAR(38)

           ,@BasisObject VARCHAR(138) = N''

           ,@Address NVARCHAR(2000) = N''

           ,@Senderaddress NVARCHAR(255) = N''

           ,@cc NVARCHAR(2000) = N''

           ,@Bcc NVARCHAR(2000) = N''

           ,@StartAt DATETIME = NULL

           ,@priority INT = 1

           ,@Xuserinserted NVARCHAR(64) = N''

           ,@GenProcID VARCHAR(38) = N''

           ,@AdditionalObjectKeysAffected QBM_YParameterList readonly

           ,@checkForExisting BIT = 0

           ,@QueueName NVARCHAR(256) = NULL

           )

    HTH, Barry.