Schedule a Query

#1 (**permalink**) 07-14-2008, 06:46 PM

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

#2 (**permalink**) 07-14-2008, 06:46 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode