USP_MKTSEGMENTATIONSEGMENTCALCULATEPROCESS_ADDRECORDCOUNTSREPORTSTATUS

Adds a marketing effort records counts process status record so you can view the record counts 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_ADDRECORDCOUNTSREPORTSTATUS]
(
  @ID uniqueidentifier output,
  @SEGMENTATIONID uniqueidentifier,
  @PARAMETERSETID uniqueidentifier
)
as
  set nocount on;

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

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

    select
      @MAILINGPREACTIVATIONPROCESSID = [ID]
    from dbo.[MKTMAILINGPREACTIVATIONPROCESS]
    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 record counts...

    exec dbo.[USP_BUSINESSPROCESSSTATUS_ADDPROCESS]
      @ID,
      '92BEFBFA-43B4-42A4-80FF-88350D540824',
      @MAILINGPREACTIVATIONPROCESSID,
      'MKTMAILINGPREACTIVATIONPROCESSSTATUS',
      @STARTEDBYUSERID,
      @SERVERNAME,
      @CHANGEAGENTID;
  end try

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

  return 0;