Hi Lowell,

Thanks for your response!

The results of the query will be sent to an AD Group. Typically there will be less than 20 records.

Here is my current SP if it helps:

USE [EQUIPMENT]

GO

/****** Object: StoredProcedure [dbo].[SP_LANES_DOWN] Script Date: 11/19/2013 11:03:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[SP_LANES_DOWN]

AS

EXEC msdb.dbo.sp_send_dbmail

@PROFILE_NAME = 'ENTSMTP',

@RECIPIENTS = 'RECIPIENTS@ANYCOMPANY.COM',

@QUERY ='SELECT [FACILITY NAME],[FAILURE],[CALL TRACKING NUMBER],[LANE],[DATE OPEN],[TIME OPEN]

FROM [EQUIPMENT].[DBO].[Event Log]

WHERE [Intial Up/Down] = ''DOWN'' AND [UP/DOWN] IS NULL',

@BODY = 'The following facility(ies) have lanes down',

@SUBJECT = 'Lane Down Repair Request';

Thank you!

Keith