alter procedure [dbo].[alert_nav_jobqueue_test]
as

Begin

declare @alerttriggered AS varchar(max);

set @alerttriggered = 'SELECT [ID], [Description], [Start Date_Time], [Status], [E-Mail Sent], [Job Queue Category Code]
FROM [MyDatabase].[dbo].[TEST My Company$Job Queue Log Entry]
WHERE cast([Start Date_Time] as date) = cast(getdate() as date) AND [Status] != 0 AND [E-Mail Sent] >0'

IF @@ROWCOUNT > 0
BEGIN
EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'Primary SMTP Profile',
    @recipients = 'myemail@domain.com',
    @query = @alerttriggered ,
    @subject = 'Alert from TEST NAV Job Queue Entry ',
    @Body = '' ,
    @query_result_header= 0,
    @attach_query_result_as_file = 0,
    @append_query_error = 0;
END
ELSE
DECLARE @t int
END;