473,811 Members | 3,213 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1710
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
1725
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 events by location, by quarter of the year. Therefore, I have two flat files. This one shows what is allowed by quarter of the year:
1
1114
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 from a datasource and filing out an hourly schedule? How do you deal with the empty hours if you're using a datagrid? Thx.
5
2323
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 within that record. Say you want to
3
3678
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 This database has tables that are links using ODBC, so when you open the query it asks for the "SQL Server Login", which is different to the User Login for the PC.
3
8746
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 contains Training, Certification and Scheduling of Crew Members. I've got most of the back-end done (Tables with Relationships) and I'm happy with the Training and Certification sections. I'm having trouble with the Scheduling Part. The Table is...
3
1907
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 type is displayed on is divided into 15 minutes time intervals
2
2041
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 want this query to be executed automatically every midnight..How can i schedule it.I know about windows scheduler,but dont know can i schedule access querys.Should the scheduling job should be in the same machine where access has its querys.Thanks in...
2
7723
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 which generated by MS Access. In my MS Access, I queries and filter a lot of data from Oracle database which I connect using ODBC. In this query, there is one perimeter need to fill up. The parameter is date. It's a range of date. Every Monday...
1
1186
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
9607
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10408
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10137
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9211
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6895
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5561
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5700
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3874
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3026
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.