William White
asked on
Create SQL Agent job to execute a query and save the results to a text tile
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?
select partnbr, descr, salesdesc, upc, cat1 from tbl_itemsPT
order by partnbr asc
What is a good way to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.