USP_MKTSEGMENTATIONEXPORTPROCESSSTATUSOUTPUT_UPDATESTATUS

Updates the status of a mailing export process.

Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSOUTPUTID	uniqueidentifier	IN
@NETCOMMUNITYEMAILJOBID	int	IN
@STATUSCODE	tinyint	IN
@STATUSDATE	datetime	IN
@STATUSMESSAGE	nvarchar(255)	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTSEGMENTATIONEXPORTPROCESSSTATUSOUTPUT_UPDATESTATUS]
(
  @BUSINESSPROCESSOUTPUTID uniqueidentifier,
  @NETCOMMUNITYEMAILJOBID integer,
  @STATUSCODE tinyint,
  @STATUSDATE datetime,
  @STATUSMESSAGE nvarchar(255)
)
as
  set nocount on;

  declare @BUSINESSPROCESSSTATUSID uniqueidentifier;
  declare @TABLEKEY nvarchar(50);
  declare @TABLENAME nvarchar(255);
  declare @SQL nvarchar(max);

  if @STATUSDATE is null set @STATUSDATE = getdate();

  select 
    @BUSINESSPROCESSSTATUSID = [BUSINESSPROCESSSTATUSID],
    @TABLEKEY = [TABLEKEY]
  from 
    dbo.[BUSINESSPROCESSOUTPUT] 
  where 
    [ID] = @BUSINESSPROCESSOUTPUTID;

  select
    @TABLENAME = [TABLENAME]
  from
    dbo.[BUSINESSPROCESSOUTPUT]
  where
    upper([TABLEKEY]) = upper(convert(nvarchar(36), @BUSINESSPROCESSSTATUSID))

  set @SQL = 
    'update' + char(13) +
    '  dbo.[' + @TABLENAME + ']' + char(13) +
    'set' + char(13) +
    '  [NETCOMMUNITYEMAILJOBID] = @NETCOMMUNITYEMAILJOBID,' + char(13) +
    '  [STATUSCODE] = @STATUSCODE,' + char(13) +
    '  [STATUSDATE] = @STATUSDATE,' + char(13) +
    '  [STATUSMESSAGE] = @STATUSMESSAGE' + char(13) +
    'where' + char(13) +
    '  [TABLEKEY] = @TABLEKEY';

  exec sp_executesql @SQL, N'@NETCOMMUNITYEMAILJOBID integer, @STATUSCODE tinyint, @STATUSDATE datetime, @STATUSMESSAGE nvarchar(255), @TABLEKEY nvarchar(50)', @NETCOMMUNITYEMAILJOBID = @NETCOMMUNITYEMAILJOBID, @STATUSCODE = @STATUSCODE, @STATUSDATE = @STATUSDATE, @STATUSMESSAGE = @STATUSMESSAGE, @TABLEKEY = @TABLEKEY;

  return 0;