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?