USP_EMAILJOB_SETSTATUSID

Sets the status ID of an email job.

Parameters

Parameter Parameter Type Mode Description
@EMAILJOBID int IN
@STATUSID uniqueidentifier IN

Definition

Copy


CREATE procedure dbo.USP_EMAILJOB_SETSTATUSID
(
    @EMAILJOBID int,
    @STATUSID uniqueidentifier
)
as
begin
    update dbo.EMAILJOB
    set STATUSID = @STATUSID, [WSDateLastAccessed] = GETUTCDATE()
    where ID = @EMAILJOBID
end