Compare against a list and email if variance

[prakash (JPN)]

you could either

1. write ssrs report and schedule email of the report.

or

2. run bpm on schedule and get the report.
   Using a Task Agent Schedule to run a BPM on a schedule