USP_TRANSACTIONALEMAIL_UPDATESTATUS

Updates the email status table with the external id of the email job.

Parameters

Parameter	Parameter Type	Mode
@EXTERNALJOBIDENTITY	uniqueidentifier	IN
@QUEUEID	uniqueidentifier	IN
@STATUS	int	IN

Definition

Copy



      CREATE procedure dbo.USP_TRANSACTIONALEMAIL_UPDATESTATUS
      (
        @EXTERNALJOBIDENTITY uniqueidentifier,
        @QUEUEID uniqueidentifier,
        @STATUS integer = null
      )
      as
      begin
        set nocount on;

        update dbo.EMAILSTATUSTRANSACTIONAL set EXTERNALJOBIDENTITY = @EXTERNALJOBIDENTITY, STATUS = @STATUS
          where EMAILQUEUETRANSACTIONALID = @QUEUEID;

      end