How can I schedule an SQL query and export the result to a .csv file

Biemans, Chantal 0 Reputation points
2025-04-08T09:47:34.2033333+00:00

How can I schedule an SQL query and export the result to a .csv file

SQL Server Database Engine
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Balmukund 166 Reputation points Microsoft Employee
    2025-04-08T11:44:23.1166667+00:00

    If you are using SQL Server on-prem then you can use SQL Agent to create a scheduled job which can run the query and dump the results into .csv file.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.