USP_GENERALPURPOSEEMAIL_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_GENERALPURPOSEEMAIL_CHECKQUEUESTATUS
      (
        @THREADID uniqueidentifier
      )
      as
      begin
          set nocount on;

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