I would use simple Powershell script that does this, something like:

Invoke-SqlCommand -query '...' | ExportTo-Csv ...

Generally, for administrative functions you could add this to Task Scheduler and be done with...