Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwilliams
194 Posts |
 Posted - 2003-03-20 : 12:58:04
|
| Hi,I'm completely new to SQL, but I've been working with it for about a year now. But I've never worked with creating a job besides with Replication. I have a database table that contains election information with 4 fields: Candidate, Office_Question, Votes, and Percentage. I also have an excel document that contains this information with formulas. I want the data from the Excel doc to update the DB table every 15 minutes on election day. Can anyone give me a simple step by step expanation on how to do this? I've kinda figured out the basics of how to create a job, but I don't understand how to write something for the Command box, and how to connect it with the Excel document.I've looked through the Online Books, but I'm just more confused. Thanks for any help in advance.P.S. I could also use a text file with no problem, instead of excel, if that's any easier. Thanks.Katherine Williamskwilliams@douglas-county.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-20 : 13:07:04
|
| You will want to do this in a DTS package and not directly inside a job. Then once the DTS package has been created, just schedule the DTS package to occur every 15 minutes by creating a job that executes the DTS package.Tara |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-03-20 : 13:09:26
|
| Hi Katherine!If you want to load data from an Excel document, I would advise you to create a DTS package for the task. You can create the package using the import/export wizard. (tools menu) At the end of the wizard, you will be asked if you want to schedule the package. When you do that, it appears as a job under SQL Agent. |
|
|
|
kwilliams
194 Posts |
Posted - 2003-03-21 : 09:54:20
|
| Great! Thanks for the quick responses. I was getting confused between the DTS Package and an individual job, but the way you both explained it to me really helps me to understand what I need to do. Thank you so much!!! I really appreciate your help. This is a great forum!K Williamskwilliams@douglas-county.comGO JAYHAWKS!!! |
|
|
|
|
|
|
|
|
NEWBIE: How to create a new job