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 - 2002-03-04 : 13:56:30
|
| Jason writes "Hi guys,I'm needing to execute either a stored procedure or possibly even a trigger at specific time intervals (like every hour or so). Basically what I need it to do is go through a couple of tables and flag certain columns' bit fields based on how long they've been in the table. Is this possible in MS SQL 7 or 2000? If so, could you please explain how it's done?Thanks a lot!Cheers,Jason Taucher" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 14:42:36
|
| Yes,Very easy, just shedule a job to run on any schedule you like (Every hour would be one example). The job step would be your stored procedure.-Chad |
 |
|
|
|
|
|
Executing a stored procedure at certain time intervals...