Schedule a Query

[scadreau@gmail.com]

I need to run a rather large query and want to schedule it to run this
evening. Is there a way to do that in sql server? (2005)

Thanks,

Scott

[Hugo Kornelis]

Re: Schedule a Query

On Wed, 9 Jul 2008 12:42:14 -0700 (PDT), scadreau@gmail. com wrote:

>I need to run a rather large query and want to schedule it to run this
>evening. Is there a way to do that in sql server? (2005)

Hi Scott,

You can use SQL Agent for this. Or you can write a Windows command
(.cmd) file to call osql.exe and execute the query and use windows
scheduler.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis