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 - 2004-05-07 : 11:26:40
|
| Boris writes "Here is a SQL question I hope you know answer.I need to shell out SP and not to wait for it to be completed – kind ofCreate procedure sp1 As Execute SP2 ReturnI would like : SP1 just submits SP2 do not wait until SP2 completes and quits.Can I do it in SQL or it goes against common SQL sense?Thank you" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-05-07 : 11:35:12
|
| You will need to create a job that runs SP2. Then in SP1 start that job.Jay White{0} |
 |
|
|
|
|
|
shell out stored procedure