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 |
|
pallavijyo
Starting Member
10 Posts |
 Posted - 2004-12-03 : 16:40:54
|
| hello,I have to write a program that will run 7 days per week at 9.00pm and append the data to the 3 tables in SQL 2000.Now i am not sure how to go about it.I am at lost how to go about and write a stored proc tht will run 7 days per week at 9.00pm and also append to the 3 tables?Pls can someone guide me and give a similar sample code? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-03 : 16:43:32
|
| Well write the stored procedure, then schedule it to run in SQL Server Agent. Have you setup jobs before? How far did you get in the stored procedure?Tara |
 |
|
|
pallavijyo
Starting Member
10 Posts |
Posted - 2004-12-06 : 10:10:54
|
| Thks for ur reply...i havent set up any jobs earlier! I am fine with SP ..but never done nething like this before |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-06 : 12:26:24
|
| I would start reading up on jobs in SQL Server Books Online.Tara |
|
|
|
|
|
|
write a program tht will run at 9.00pm evryday