running a daily job as a URL on a hosted server

Question

i have a hosted web site and i have an asp.net mvc site. The hosting company allows you to setup "scheduled tasks" which are basically just using the windows scheduler. The service checks a URL at whatever interval that you want but all you can supply it is a URL.

i want to have a job that runs a db query and emails out to me the results of a certain table.

My questions is how do i have just a URL that can go and run code to email out as i obviously dont need any html returned to a view in this case as its just running a task.

Answer 1

Create a controller with a method that will query the database and send you an email and map it to some route. And use the url you mapped to as an url to check. And all should work.
Or may be I just don't understand your question. In this case please update the questions with some details.