I want to automate running an SQL query and export to a file every 15 minutes

[Djay]

Hi all,

I have an SQL query that bring back data for customer contacts (name, telephone number, time of call, agent ID e.t.c) which is run manually every day.
The business now requires me to extract this data every 15 mintues, and i don't want to have to do it manually as i wont have time to anything else with my day!

I would like to find a way of running the SQL query once every 15 minutes and have it export the data to a text file, is this possible?

Cheers

Dai

[ck9663]

Yes, it's possible.

Create a job that runs every 15 minutes. Be aware that if your process runs more than 15 minutes and you create only one job, it will not run while the first instance is still running. Check first how long your process runs. Then create one or more jobs as needed.

Good Luck!!!


~~ CK

[Rabbit]

If you have SQL Server Agent, you can create an SSIS package that exports your query to a text file and schedule it to run every 15 minutes.