Normally you would have done this manually:
Time for a change!
Schedule it in SQL Agent as a Stored Procedure and export it to a TXT-file.
To export it to a TXT-file:
SQL Agent Job – ExportDatasetToTXT
Make sure that xp_cmdshell is enabled:
EXEC master.dbo.sp_configure 'show advanced options', 1
EXEC master.dbo.sp_configure 'xp_cmdshell', 1