USP_GENERALPURPOSEEMAIL_UPDATECHUNKINGSTATUS

Updates the queueing status of the email

Parameters

Parameter	Parameter Type	Mode	Description
@QUEUEID	uniqueidentifier	IN
@CHUNKPROCESSING	int	IN

Definition

Copy



      CREATE procedure dbo.USP_GENERALPURPOSEEMAIL_UPDATECHUNKINGSTATUS
      (
        @QUEUEID uniqueidentifier,
        @CHUNKPROCESSING integer
      )
      as
      begin
          update dbo.EMAILQUEUEGENERALPURPOSE set CHUNKPROCESSING = @CHUNKPROCESSING, FIRSTPOLLSTARTED = case when @CHUNKPROCESSING = 0 then 0 else FIRSTPOLLSTARTED end where ID = @QUEUEID;
      end