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

---

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

---

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.

---

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.

---

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