Is it possible to use task scheduler to open a database, choose a report to run, e-mail the results of the report then close the database? I'm having a hard time figuring out how to choose the report I want to run after I open the database. Thanks for the help!

If you can perform these tasks with console commands then you can schedule them. In other words, your first job is to find the appropriate console commands. Mailing the result is easy.

After I figure out the console commands would it be easier to create a batch file, then run the batch file from the task scheduler?

After I figure out the console commands would it be easier to create a batch file, then run the batch file from the task scheduler? Yes.

I would never have figured that out on my own! Thanks! :) Now I just have to figure out the commands! lol