USP_TRANSACTIONALEMAIL_GETSTATUS

Retrieves the status of a transactional email.

Parameters

Parameter Parameter Type Mode Description
@STATUSID uniqueidentifier IN

Definition

Copy


      CREATE procedure dbo.USP_TRANSACTIONALEMAIL_GETSTATUS
      (
        @STATUSID uniqueidentifier
      )
      as
      set nocount on;
      begin
          select ID, EMAILQUEUETRANSACTIONALID, STATUS, STATUSMESSAGE, DATEADDED, EXTERNALJOBIDENTITY from dbo.EMAILSTATUSTRANSACTIONAL
          where ID = @STATUSID;
      end