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 |
|
ssrikrish
Yak Posting Veteran
69 Posts |
 Posted - 2007-12-25 : 11:22:01
|
| Team:How to invoke a stored procedure "out of process", meaning i want to add it to a queue.Reason: we have a proc that is fired real-time each time an order comes into the system and it take a few seconds and when there is plenty of order activity in the system, the process times out. I would like to essentially add this to a queue and move on and some other process will process from the queue. Is CLR call the way to do? I know that the easiest way can be to add to a table and process from the table every 5 mins or something like that. Thoughts?ThxSri |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-25 : 12:22:05
|
| We had faced a similar problem in our project. What we did was to stage the records to be processed onto a staging table and then a job was scheduled to run every 15 mts which picks up the staged records and processes them by executing the SP. |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-12-25 : 14:00:39
|
| SQL Server 2005 has a new feature that will do exactly what you want, it's called the Service Broker. Just look that up in Books Online. |
|
|
|
|
|
|
out of process SP invoke