USP_EMAILJOB_SETSTATUS

Updates the status of an email job.

Parameters

Parameter	Parameter Type	Mode
@EMAILJOBID	int	IN
@STATUS	int	IN
@STATUSTEXT	nvarchar(32)	IN
@ERRORTEXT	nvarchar(max)	IN
@VERBOSE	bit	IN

Definition

Copy



CREATE procedure dbo.USP_EMAILJOB_SETSTATUS
(
    @EMAILJOBID int,
    @STATUS int,
    @STATUSTEXT nvarchar(32),
    @ERRORTEXT nvarchar(max),
    @VERBOSE bit = 0
)
as
begin

    update dbo.EMAILJOB
    set STATUS = @STATUS, [WSDateLastAccessed] = GETUTCDATE()
    where ID = @EMAILJOBID;

    declare @EMAILID int;

    select @EMAILID = EMAILID from dbo.EMAILJOB where ID = @EMAILJOBID;

    if @EMAILID > -1
    begin
        insert into [dbo].[EMAILJOBSTATUS] (EMAILID, EMAILJOBID, STATUS, ERRORTEXT, VERBOSE)
        values(@EMAILID, @EMAILJOBID, @STATUSTEXT, @ERRORTEXT, @VERBOSE)
    end

end