You can do so by developing Windows Service or Some costume application.
but if you want a good solution then :
just write those query's which result you need sequentially
then save it in a SQL
sqlcmd -S CAFRFD1LITPMA02 -i SQL FileName
-o OutPutFileName [CSV | TXT ]
run this code in a Schedule, if you need individual files One by one then just change output file name Uniquely.
For that just add Date Time with file name using Commend Prompt
you can save this hole as Batch file and run it under Scheduler.
Commend Prompt Details Click Here
For More Help Reffer : http://social.msdn.microsoft.com/Forums/en/transactsql/thread/b3f406e1-1b2e-4ee4-8d28-4470c0ea19f9