How can i run a sql query on a schedule without us

问题:

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

回答1:

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

回答2:

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.

回答3:

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.

回答4:

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