USP_GENERALPURPOSEEMAIL_UPDATESTATUS

Updates the email status table with the external id of the email job.

Parameters

Parameter	Parameter Type	Mode
@EXTERNALJOBIDENTITY	uniqueidentifier	IN
@QUEUEID	uniqueidentifier	IN
@STATUS	int	IN
@PROCESSINGID	uniqueidentifier	IN

Definition

Copy



      CREATE procedure dbo.USP_GENERALPURPOSEEMAIL_UPDATESTATUS
      (
        @EXTERNALJOBIDENTITY uniqueidentifier = null,
        @QUEUEID uniqueidentifier = null,
        @STATUS integer = null,
        @PROCESSINGID uniqueidentifier
      )
      as
      begin
        set nocount on;

        begin tran UPDATEJOBSTATUS
        begin try
          update dbo.EMAILQUEUEGENERALPURPOSE set EXTERNALJOBIDENTITY = @EXTERNALJOBIDENTITY
            where ID = @QUEUEID;

          update dbo.EMAILSTATUSGENERALPURPOSE set EXTERNALJOBIDENTITY = @EXTERNALJOBIDENTITY, STATUS = @STATUS
            where EMAILQUEUEGENERALPURPOSEID = @QUEUEID and STATUS <> 18;
        end try
        begin catch
          if @@trancount > 0
            rollback tran UPDATEJOBSTATUS
                exec dbo.USP_RAISE_ERROR
            return 0
        end catch
        if @@trancount > 0
          commit tran UPDATEJOBSTATUS
        -- delete from active chunk table

        --delete from dbo.EMAILACTIVECHUNK

        --    where THREADID = @PROCESSINGID;


      end