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