I would imagine you could even conceive of creating these jobs and then kicking them off on a schedule based on Reporting Services Scheduled Reports, or using the windows task scheduler and an OSQL command or a variety of other resources.
There are a variety of frameworks and applications on codeplex and CodeProject amoung others to get around these same issues...
This is just the first one from Google...