job scheduler

Dear friends,

Currently i am running a large sql server 2000. Usually when i need to generate reports, i will need to query using query analyser and paste the result in excel. This process is very tedious as the query takes long time due tolarge data. Also my reports have the frequency of daily, weekly and monthly.

I am looking for a job/query scheduler to automate this process and publish the result in excel.

I understand that DTS can only schedule a query to run but extracting the data to excel and Reporting Services does not have scheuler.

Please advise if there is any s/w or application can do this. Any freebies?

Cheers,
Darren

The DTS can run a query and deliver the results into an excel, ms access, csv or whatever format. And this can be scheduled as well.

Hie Victor,

Thanks for your reply, but i am looking for something like http://www.dkgadvancedsolutions.com/dbscheduler.htm
It is a cool tool but its not free..

any other s/w u know of?

Are you looking for free software only? If you have an MS SQL license why not use DTS? Data Junction is nice but it is not free either.
...
If you do not like dts you can script the export utility.

By far the best way to do this is to use a DTS package. You can create a Transform Data Task that can use your SQL Server as a source and an Excel spreadsheet as a target and will be able to populate it using any query you specify.
(see attached screenshot - package.jpg)

You can then schedule the package to run whenever you need it to. (schedule.jpg)

i would definitely use DTS, there's always straight bcp.