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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-12 : 08:41:09
|
| Suni writes "I want to write an automated batch process, which executes every "n" days. Its function is to change the value of a field of a table. How do I do it ? Can this be done at the SQL Server side ? Or do I need to do it thro' from ASP ?Please advice.." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2001-12-12 : 09:10:45
|
| Write a Stored procedure to do the update. Then look to use Enterprise Manager to schedule it (look under Management section).Everything you need will be in there....experiment! |
 |
|
|
|
|
|
Automated Batch process to update a table every n days