USP_FEEDALERT_GETPROCESSPARAMETERS

This procedure returns parameters used by the feed alert send process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALISTID	uniqueidentifier	INOUT
@EMAILSUBJECT	nvarchar(255)	INOUT
@EMAILBODY	nvarchar(max)	INOUT
@LASTRUN	datetime	INOUT
@EMAILISENALBED	bit	INOUT
@CUSTOMALERTMESSAGESIZE	int	INOUT
@CUSTOMALERTMESSAGESIZETOTAL	int	INOUT

Definition

Copy



CREATE procedure dbo.USP_FEEDALERT_GETPROCESSPARAMETERS
(
    @ID uniqueidentifier,
    @DATALISTID uniqueidentifier output,
    @EMAILSUBJECT nvarchar(255) output,
    @EMAILBODY nvarchar(max) output,
    @LASTRUN datetime output,
    @EMAILISENALBED bit output,
  @CUSTOMALERTMESSAGESIZE integer output,
  @CUSTOMALERTMESSAGESIZETOTAL integer output
)
as
begin
    set nocount on;

    select
        @DATALISTID = DATALISTID,
        @EMAILSUBJECT = EMAILSUBJECT,
        @EMAILBODY = EMAILBODY
    from
        dbo.ALERTTYPE
    where
        ID = @ID;

    set @EMAILISENALBED = 0;
    select top 1 
        @EMAILISENALBED = coalesce(ENABLED, 0)
    from dbo.DATABASEMAILSETTINGS

    set @LASTRUN = (
        select top(1)
            STARTEDON
        from
            dbo.BUSINESSPROCESSSTATUS
        where
            BUSINESSPROCESSPARAMETERSETID = @ID
        and
            STATUSCODE = 0
        order by
            STARTEDON desc
       );      

  select 
    @CUSTOMALERTMESSAGESIZE = isnull(CUSTOMALERTMESSAGESIZE,0), 
    @CUSTOMALERTMESSAGESIZETOTAL = isnull(CUSTOMALERTMESSAGESIZETOTAL,0)
  from dbo.INSTALLATIONINFO;

    return 0;
end