USP_TASKREMINDERALERT_GETALERTINFORMATION

Gets the information associated with the 'Task reminder alert'.

Parameters

Parameter	Parameter Type	Mode	Description
@EMAILBODY	nvarchar(max)	INOUT
@EMAILSUBJECT	nvarchar(255)	INOUT

Definition

Copy



create procedure dbo.USP_TASKREMINDERALERT_GETALERTINFORMATION
(
    @EMAILBODY nvarchar(max) output
    , @EMAILSUBJECT nvarchar(255) output
)
as
begin
    set nocount on;

    select
        @EMAILBODY = ALERTTYPE.EMAILBODY
        , @EMAILSUBJECT = ALERTTYPE.EMAILSUBJECT
    from
        dbo.ALERTTYPE
    where
        ALERTTYPE.ID = '02863BF9-BA85-481E-8AA0-CC60758C6789';

    return 0;
end