Hi Sean, please can you check...

CREATE TRIGGER tgr_SM7EmailQ

ON TBL_EVENTOUTm1

AFTER INSERT

AS

BEGIN

SELECT COUNT(*) AS EMAILQFULL, [evtype]

FROM EVENTOUTM1

GROUP BY [evtype]

HAVING COUNT(*)>= 90

EXEC msdb.dbo.sp_send_dbmail @profile_name='profile name',@subject='Email Q Rows Filling up', @recipients ='email address',@body = 'The Row is over 90 please check'