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 |
|
Goalie35
Yak Posting Veteran
81 Posts |
 Posted - 2007-12-28 : 16:41:58
|
| I've been assigned the task of updating a table nightly but I have no clue how to do this.Basically, I need to pull data from a gargantuan database and place a few fields of data into a smaller table once a night so it's more manageable for reporting purposes.I'm assuming I have to schedule something but what? And where do I schedule it?Thanks.-Goalie35 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-28 : 16:45:27
|
| look at the scheduled jobs in sql server._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-28 : 22:47:33
|
| You can copy data with data import/export wizard and schedule to run it. |
|
|
|
|
|
|
Updating a table nightly??