How to create a job or use export wizard to export result of a query to Excel on a daily base automatically on SQL server 2016? Basically I want to get an excel file generated daily for a query and get saved in a particular location without manually exporting the result daily. Thanks.
welcome to the forum
you have many options
Which one are you more comfortable with?
I've not used either but I could use SSIS or Powershell if I'm given step by step procedure. Sorry for not being a pro but I've never used either of them before. I though I could have done this by scheduling a task or something of this sort but couldn't find the right options
google is your friend