USP_EMAIL_GETACTIVEPROCESSNAMES

Returns the thread names of active email processes as stored in the database.

Parameters

Parameter	Parameter Type	Mode	Description
@PROCESSTYPE	nvarchar(50)	IN

Definition

Copy



      create procedure dbo.USP_EMAIL_GETACTIVEPROCESSNAMES
      (
        @PROCESSTYPE nvarchar(50)
      )
      as
      begin
      set nocount on;
          select THREADNAME from dbo.EMAILPROCESSTRACKING where PROCESSTYPE = @PROCESSTYPE and ISACTIVE = 1;
      end