USP_EMAIL_CREATEUPDATE_INVALIDACCOUNT

This stored procedure will either update or insert an invalid email account (as determined by bounce from external service).

Parameters

Parameter	Parameter Type	Mode
@EMAILADDRESS	varchar(255)	IN
@EXTERNALJOBID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



      CREATE procedure dbo.USP_EMAIL_CREATEUPDATE_INVALIDACCOUNT
      (
        @EMAILADDRESS varchar(255),
        @EXTERNALJOBID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier = null
      )
      as
      begin
          set nocount on;

        if @CHANGEAGENTID is null
          exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        begin try
          if (select top 1 1 from dbo.EMAILINVALIDRECIPIENT where ADDRESS = @EMAILADDRESS) = 1
          begin
            update dbo.EMAILINVALIDRECIPIENT set FAILEDATTEMPTS = FAILEDATTEMPTS + 1, CHANGEDBYID = @CHANGEAGENTID
              where ADDRESS = @EMAILADDRESS and EXTERNALJOBIDENTITY <> @EXTERNALJOBID;
          end
          else
          begin
            insert into dbo.EMAILINVALIDRECIPIENT (ADDRESS,
                                                   FAILEDATTEMPTS,
                                                   ADDEDBYID,
                                                   CHANGEDBYID)
                                          values  (@EMAILADDRESS,
                                                   0,
                                                   @CHANGEAGENTID,
                                                   @CHANGEAGENTID);
          end                                         
        end try
        begin catch
          exec dbo.USP_RAISE_ERROR;
              return 1;
        end catch

      end