detect if a package/stored proc/email has already been run/exec/sent??? -- sql server dts

micenmen
4/21/2006 9:18:04 AM

Allo,

I've set up a system that sends out an email if certain defect levels
are in my DB are met. The system consists of a DTS package that
processes the cubes, then runs a sql task that executes a stored proc
to check levels and send out an email with xp_sendmail if they are too
high. I would like to send that email out only once when the criteria
is met. We process our cubes every minute and we do not need an email
sent out every minute until the problem is corrected. I'm a bit new to
all this, and would love any ideas or feedback.

Thanks!

-Joey

Allan Mitchell
4/21/2006 12:53:33 PM

So have a flag somewhere in the database that you check to see if the eMail
has been set within the last valid period (Hour/Day/Week). If it has then
do not resend else send.

--

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

sql server dts : detect if a package/stored proc/email has already been run/exec/sent???