USP_TRANSACTIONALEMAIL_CHECKQUEUESTATUS

This will check the status of all queued records except those specified in the @THREADID or with a ThreadId = guid.empty

Parameters

Parameter	Parameter Type	Mode	Description
@THREADID	uniqueidentifier	IN

Definition

Copy



      create procedure dbo.USP_TRANSACTIONALEMAIL_CHECKQUEUESTATUS
      (
        @THREADID uniqueidentifier
      )
      as
      begin
          set nocount on;

          select Q.ID, DATEADDEDTOQUEUE, EXTERNALJOBIDENTITY from dbo.EMAILQUEUETRANSACTIONAL Q
            inner join dbo.EMAILSTATUSTRANSACTIONAL S on Q.ID = S.EMAILQUEUETRANSACTIONALID
            where THREADID <> @THREADID and THREADID <> '00000000-0000-0000-0000-000000000000' 
      end