USP_MKTSEGMENTATIONSEGMENTCALCULATEPROCESS_ADDEXCLUSIONSREPORTSTATUS

Adds a marketing effort exclusions process status record so you can view the exclusions history for a marketing effort.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@SEGMENTATIONID	uniqueidentifier	IN
@PARAMETERSETID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.[USP_MKTSEGMENTATIONSEGMENTCALCULATEPROCESS_ADDEXCLUSIONSREPORTSTATUS]
(
  @ID uniqueidentifier output,
  @SEGMENTATIONID uniqueidentifier,
  @PARAMETERSETID uniqueidentifier
)
as
  set nocount on;

  declare @STARTEDBYUSERID uniqueidentifier;
  declare @SERVERNAME nvarchar(255);
  declare @CHANGEAGENTID uniqueidentifier;
  declare @SEGMENTATIONEXCLUSIONSPROCESSID uniqueidentifier;

  begin try
    if @ID is null
      set @ID = newid();

    select
      @SEGMENTATIONEXCLUSIONSPROCESSID = [ID]
    from dbo.[MKTSEGMENTATIONEXCLUSIONSPROCESS]
    where [SEGMENTATIONID] = @SEGMENTATIONID;

    --Grab some information from the currently running mailing segment calculation process...

    select top 1
      @STARTEDBYUSERID = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID],
      @SERVERNAME = [BUSINESSPROCESSSTATUS].[SERVERNAME],
      @CHANGEAGENTID = [BUSINESSPROCESSSTATUS].[ADDEDBYID]
    from dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS]
    inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[ID]
    where [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[PARAMETERSETID] = @PARAMETERSETID
    order by [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[DATEADDED] desc;

    --Add a new status for the mailing exclusions...

    exec dbo.[USP_BUSINESSPROCESSSTATUS_ADDPROCESS]
      @ID,
      '80988580-B272-4A6F-BD65-4613CE579236',
      @SEGMENTATIONEXCLUSIONSPROCESSID,
      'MKTSEGMENTATIONEXCLUSIONSPROCESSSTATUS',
      @STARTEDBYUSERID,
      @SERVERNAME,
      @CHANGEAGENTID;
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;