USP_EMAILJOBDATA_CREATEORUPDATE

Create or edit an email job data

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@EMAILJOBID	int	IN
@DATA	xml	IN
@RECIPIENTCOUNT	int	IN
@SENT	bit	IN

Definition

Copy



CREATE procedure dbo.USP_EMAILJOBDATA_CREATEORUPDATE
(
      @ID uniqueidentifier = null output,
    @EMAILJOBID integer,
    @DATA xml,
    @RECIPIENTCOUNT integer,
    @SENT bit
)
as

    set nocount on;

    begin try

    if @ID is null 
    begin
      set @ID = newid();
      insert into EMAILJOBDATA values (@ID, @EMAILJOBID, @DATA, @RECIPIENTCOUNT, @SENT)
    end
    else
    begin
      update dbo.EMAILJOBDATA 
      set EMAILJOBID = @EMAILJOBID,
        DATA = @DATA,
        RECIPIENTCOUNT = @RECIPIENTCOUNT,
        SENT = @SENT
      where ID = @ID
    end
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;