CODEWITHSUNDEEP
sql-servert-sql
RP.
RP.

Reputation: 23

How can i run a sql query on a schedule without using sql server agent jobs( & no BI too) and pump the results in an excel file

I want to run a sql query on a specific schedule (weekly) and need to capture the output in an excel file as well.

Due to business restrictions we cannot use SQL server jobs and we cannot install Business Intelligence tools too.

Regards, RP

Upvotes: 2

Views: 5710

Answers (4)

Darryl Peterson
Darryl Peterson

Reputation: 2270

Use Windows Scheduled Tasks and a VBScript. The VBScript connects to the database to run the query and populates the Excel file with the results.

The following URL is an example.

http://digiassn.blogspot.com/2006/10/vbscript-populating-excel-file-from.html

Upvotes: 0

Hassan Syed
Hassan Syed

Reputation: 20496

Convince your company to stop being so obtuse -- you will end up writing a .NET app that acts as a service anyway -- its swings and roundabouts.

Upvotes: 1

KM.
KM.

Reputation: 103677

set a Windows schedule task to run the osql Utility, which can fire off your SQL

Upvotes: 1

Randy Minder
Randy Minder

Reputation: 48522

That pretty much rules out letting SQL Server do this for you. One alternative then is to create a Windows Service that contains a timer that fires on a schedule, that executes the query you need to do.

Upvotes: 0

Related Questions