I would like to create a SQL Agent job to execute a simple query and save the results to a text file daily. The query is a simple one like the following:
select partnbr, descr, salesdesc, upc, cat1 from tbl_itemsPT
order by partnbr asc
What is a good way to do this?