dts job: comparing values

Last Post 23 Jan 2007 09:16 AM by GoodFella3993. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
GoodFella3993
New Member
New Member

--
23 Jan 2007 05:54 AM
I have a project where I am to create a DTS job that will Insert queried results in a table. (such as the record count of a particular query) This will happen every week. If the record count of the particular query jumps by more than 10% it should set off a warning and send an email alert. (ex: last week count = 1000, this week count = 600)

How would i go about doing this?
GoodFella3993
New Member
New Member

--
23 Jan 2007 09:16 AM
What kind of coding would you suggest? I need to select the the 2 most recent dates and compare a field.

Thank You,
-Marc


Acceptable Use Policy
---