We are looking for a small task, u need to write a script that will run at a specified time based on some scheduled timing. The data will be in a table, your script will run and extract the data from the table and placing the data in an excel sheet and send the mail with the attachment to a specified list of emails. While sending the email, generate a log file to log the activity success and failure to troubleshoot the problem if any.
This has to run as a service.
We have MS SQL 2008 and ASP.net/ASP classic to work on