473,326 Members | 2,010 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Schedule a Query

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
Jul 9 '08 #1
1 1695
On Wed, 9 Jul 2008 12:42:14 -0700 (PDT), sc******@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
Jul 9 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: argniw | last post by:
I have a schedule of annual events that need to occur in different locations throughout the year. Each event has a due date associated with it. I also have an optimal schedule that consolidates...
1
by: Wayne Carlaw | last post by:
We'd like to begin coding a schedule application, much like Outlook and wanted some opinions on what the best approach to this project would be. Does anyone have any experience pulling appointments...
5
by: Notgiven | last post by:
You want to check scheduling conflicts and you have a record like: appointments(table): apptID beginningDate endingDate beginningTime endingTime It's easy enough to check if a time is...
3
by: Danny.McCarthy | last post by:
I have a database that I would like to schedule to open and run a macro, which is easy enough; C:\Program Files\Microsoft Office\Office Msaccess.exe Nav_Stock_Values.mdb /x RunInventoryReport ...
3
by: tstutting | last post by:
Hello, This is my first post and I'd really appreciate any help I can get. Sorry this is so long but it's complicated. I'm a USAF Officer and I'm attempting to make a shared MS Access DB that...
3
by: assgar | last post by:
Hi I am having problem with my loping. I don't know if I have chosen the correct approach. GOAL: I need to insert into a table event types for a specific date range. The calendar the event...
2
by: ramdil | last post by:
Hi All I have a doubt regarding the scheduling a task in msaccess.I want to write a query which will insert into a temporary table from a exisiting table.I have written the insert query but i...
2
by: ami'n | last post by:
i'm also not newbie to Access but i'm not programmer. I have a need to automate some task in Access. Every monday which is the first day of the week, I have to send a MS Excel file containing data...
1
by: mary mathews | last post by:
hi, Is it possible to write sql job scheule using sql query in query analyzer. i dont have an enterprise edition.so i want to know how to write sql query to schedule a job?? can anybody help??
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.