Scheduled Query to Export to a daily xls file

Question

Scheduled Query to Export to a daily xls file

tristan.keaster

SSC Enthusiast

Points: 157
More actions
June 17, 2015 at 9:50 am

#398615

Hello,
I'm brand new to the forum and extremely green when it comes to SQL, I'm using SSMS 2012. I have multiple queries that are run daily(I also have a few that are run every Monday) that I want to schedule to run at midnight and export to a new xls file on the network drive to be used the next morning. Is there something that I can add to each query to accomplish this or would I have to set something else up to call the queries?
TIA,
Tristan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 1

tristan.keaster (6/17/2015)
Hello,
I'm brand new to the forum and extremely green when it comes to SQL, I'm using SSMS 2012. I have multiple queries that are run daily(I also have a few that are run every Monday) that I want to schedule to run at midnight and export to a new xls file on the network drive to be used the next morning. Is there something that I can add to each query to accomplish this or would I have to set something else up to call the queries?
TIA,
Tristan

Please , could you tell us the full edition of your SQL Server ( Express , Express with Advanced Services , Standard , or higher ones ) ?

If you have an Express with Advanced Services , you may use the Reporting Services to create your xls file but as the SQL Agent service is disabled for all the Express editions , you may create a task thru the Windows Scheduler to create and export your xls file.

With a "normal" Express edition ( without Advanced Services ) , you can create your xls file and export it thru an application thru the Windows Scheduler ( so more complicated )

With a Standard Edition , you can use the SQL Agent Service to create your file and export it ( if the Reporting Service is installed and the SQL Agent Service enabled ).

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 2

I have forgotten to tell you that you can use PowerShell to create job.

A possibly useful link :

from the SQL Server Central site.

tristan.keaster SSC Enthusiast Points: 157 More actions · Answer 3

Not really sure of the version that I'm using. Late yesterday evening our system admin actually got back to me that he'll be able to set this up for me. I'd still like to be able to do this myself but the immediate issue has been resolved. One issue that I think I might be up against however is that I've read something that said I had to access the Server Agent, I don't have that in my Object Explorer window so I'm thinking I'm probably also up against a permissions issue. I may or may not be able to have that resolved.

Thanks for the info.