You can run a Sql Command in the scheduled job to do the desired task for you. Following is the syntax for the same.

SQLCMD -S YourSQLServer -d YourDatabase -U YourUserName -P YourPassword -Q “Your Query” -s “,” -o “C:\Yourfilename.csv"

Feel free to get back in case of any issues.