If it's for reports try SQL Reporting Services where you can schedule reports delivered to users.

So you can run stuff overnight, overweekend or in offpeak periods and deliver it to users by mail