Automated Email Notifications using SQL Server Job Scheduler

Hi Mudassar,

Great article in below link:

http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx

With regard to this I want to know how to automate email sending when say a column in a table falls within a range of values.

Say in the front end I build an alert interface,where if values in a field are in a 1-5 range I want to trigger an email with the report.

I have tried but it does not work...please help with a stored procedure that will help compare user input values with the database values and if it is in range trigger email automatically.

Also I may want to schedule the alerts to be triggered at a regular basis.Where I create a job and it automatically triggers email when the DB values are in range.So the database check may take place daily,hourly or monthly.

It will be great if you can please help with this requirement..

Thanks in Advance