USP_GENERALPURPOSEEMAIL_GETSTATUS
Retrieves the status of a general purpose email.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STATUSID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_GENERALPURPOSEEMAIL_GETSTATUS
(
@STATUSID uniqueidentifier
)
as
set nocount on;
begin
select ID, EMAILQUEUEGENERALPURPOSEID, STATUS, STATUSMESSAGE, DATEADDED, EXTERNALJOBIDENTITY, PROCESSAFTERDATE from dbo.EMAILSTATUSGENERALPURPOSE
where ID = @STATUSID;
end