Schedule SQL Server query to execute and output a file

Question

Alright guys, this should be a very simple request. I'd like to run a query (IE Select * from tablex) every night and have it automatically output to a text file on the same system.

Thanks

Have a look at SSIS packages for Standard+ installations, or Windows Task Scheduler and SQLCMD for Express editions (or as alternative). — RichardTheKiwi
– RichardTheKiwi, Commented Mar 8, 2011 at 21:33

Mark Brackett · Accepted Answer · 2011-03-08 21:42:31Z

11

Create a new SQL Server Agent job, in the step put in your SELECT statement. In Advanced, tell it to output to a file. Done.

answered Mar 8, 2011 at 21:42

Mark Brackett

85.9k17 gold badges113 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

octopusgrabbus Over a year ago

Thanks for answering this in the scope of the question, rather than recommending something else.

gbn · Accepted Answer · 2011-03-08 21:40:06Z

1

Look at bcp.exe scheduled via Windows for possibly the simplest way...

answered Mar 8, 2011 at 21:40

gbn

434k84 gold badges602 silver badges690 bronze badges

Collectives™ on Stack Overflow

Schedule SQL Server query to execute and output a file

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related