One option would be to create a stored procedure using xp_cmdshell (which is disabled by default) to call bcp, and schedule a task to execute it.
Something like this:
CREATE PROCEDURE yourProcedure AS
EXEC master..xp_cmdshell 'bcp "SELECT * FROM yourDB.dbo.yourTable" queryout "c:\text.txt" -c -T'
REGISTER or login: