USP_EMAIL_DELETEHISTORY

Deletes historical status information

Parameters

Parameter	Parameter Type	Mode
@DELETETRANSACTIONAL	bit	IN
@DELETEGENERALPURPOSE	bit	IN
@MAXDATETOSAVE	datetime	IN

Definition

Copy



      CREATE procedure dbo.USP_EMAIL_DELETEHISTORY
      (
        @DELETETRANSACTIONAL bit,
        @DELETEGENERALPURPOSE bit,
        @MAXDATETOSAVE datetime
      )
      as
      begin
          if @DELETETRANSACTIONAL = 1
        begin
          begin tran PURGEDATA
            begin try
              delete from dbo.EMAILSTATUSTRANSACTIONAL where STATUS not in (15,1,7,8,10) and CLIENTPROCESSENDDATE < @MAXDATETOSAVE;
            end try
            begin catch
              select error_number() as ERRORNUMBER
              if @@trancount > 0
                rollback tran PURGEDATA
            end catch
            if @@trancount > 0
              commit tran PURGEDATA
        end

        if @DELETEGENERALPURPOSE = 1
        begin
          begin tran PURGEDATA
            begin try
              delete from dbo.EMAILSTATUSGENERALPURPOSE where STATUS not in (15,1,7,8,10) and CLIENTPROCESSENDDATE < @MAXDATETOSAVE;
            end try
            begin catch
              select error_number() as ERRORNUMBER
              if @@trancount > 0
                rollback tran PURGEDATA
            end catch
            if @@trancount > 0
              commit tran PURGEDATA
        end
      end