I have one critical issue in my application. But we cant able to find the root cause of the same. So I have decided to write one consistency check for that issue and I want that be run in the midnight and the results should be automatically mailed to my mail id. Is it possible with SQL SERVER? Or have to create a temp table for that exception and make the consistency should insert the records every time it runs.?
I have configured my mail id also. But still I cant able to receive the output to my mail.Please anyone help me. As I am pure developer I want to know in details like step by step. If any articles there in net also please refer me.
Thanks in advance.