I have an end user that gave me a bunch about 9 different criteria that they would like to see in a bi-weekly report, preferably emailed to him automatically. I have created all of the SQL queries needed in the Query Analyzer and quite honestly he would be happy with just the results in the format that it produces when you send the results to file which produces a .rpt file. So basically I am looking for the best way to set this up as an scheduled email. I am using MS SQL 2000.

Do I have to write an app to throw in the scheduled tasks of the server?

I saw something about maybe using xp_sendmail but not quite sure what I would do there. Would I have to break up my batch SQL to separate stored procs? If I went the xp_sendmail route how would I trigger it bi-weekly?

Is it time for some professional SQL training? :P

Thanks for any input.