I have a View in an SQL Server 2008 database which I need to be exported into a CSV file automatically at the beginning of each month. As I understand, two procedures are needed:
- The SQL script to automate the export
- Schedule this task in SQL or Windows
How can I do this?