Is SQL Mail the way to go?

[bessebo]

We are currently running SQL2K and there is a desire within the business organization to be alerted with emails when certain criteria are met within the database. XP_Sendmail seems like it would satisfy the request. I would simply run a procedure on say a 1 minute interval and it would check for the database criteria and then send an email if this criteria has been met. I am interested in anyone out there who uses xp_sendmail for such a need. If not, are there better options?

We also run Crystal Enterprise 9 which uses the concept called Events and I use this functionality but more for sending out reports if certain criteria are met in a particular day. I run a procedure that will set a flag if criteria is met for the day just passed. I'm not sure if using Events in Crystal Enterprise is a good solution for a continuous checking of the database for criteria.

I would appreciate any advice in this area.

Regards,
Bessebo

 

[mrdenny]

xp_sendmail would definetly work for this. Google for xp_smtp_sendmail and check that out. It allows for the sending of emails without using MAPI by using SMTP directly.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bessebo]

Thanks for the info. We use SMTP for emailing within Crystal Enterprise. I'll let ya know how I make out.

Thanks Again,
Bessebo