I've need to monitor a stored procedure and if it returns no rows then issue an email alert. I have the SQL statement which would be :-
exec [BDirectSFH].[Core].[Util_OrderDelayMonitor] 'E'
but I need a script that will do the above check and if no rows are returned then send an email alert out. Sadly I have no scripting skills to be able to do this so wondered if anyone has done anything similar before and could share any sample code?