Just another way to do this with Powershell:

Invoke-Sqlcmd -Query "SELECT * FROM your_table;" -ServerInstance yourserver -Database yourdatabase | export-csv your.csv

It can also be scheduled as you will any other task.