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 |
|
e_rider
Starting Member
2 Posts |
 Posted - 2007-08-03 : 02:03:05
|
| I have a sproc which will create new records but I need to be calling it regularly. It's kind of like the Stock Sample but the condition is more complex, and instead of sending messages I need to be creating new records.Can someone suggest how I would approach this problem?Thanks a bunchMike |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-08-03 : 02:47:13
|
| SQL Server lets you schedule tasks, I'd put your proc in there.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
e_rider
Starting Member
2 Posts |
Posted - 2007-08-04 : 12:41:29
|
| Thanks, that works well |
|
|
|
|
|
|
Invoking a sproc on a regular interval