I can't imagine NOT having SQL Server Agent jobs that are checking things. I've used jobs, and even some RS reports with subscriptions to monitor data integrity. I had to do it to protect myself at times. I had one instance where the same data had to be entered into 3 systems (don't start, I wanted to automate the users didn't) and if you missed one there were calls made in the middle of the night. One user claimed that someone was intentionally deleting data they had entered in to one of the systems. Well, I then wrote an audit system that emailed their entire department whenever data was entered, changed, or deleted on that system and emailed weekly whenever there was inconsistent data between systems. Imagine my surprise when this person no longer had any problems!:P