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-06-28 : 09:50:19
|
| Noel writes "Hi,I am running a stored procedure from a scheduled job. The procedure uses a cursor to repeatedly execute the sp_makewebtask command to generate xml files. the problem I am having is that if there is a problem generating one of the files I want the process to continue and generate all the rest of the xml files. What happens is that once the scheduled task sees an error it halts execution. If I execute the process interactively in Query analyser it does not behave like this and will continue to generate files even after sp_makewebtask returns an error.And ideas ?Thanks.Noel." |
|
|
|
|
|
sp_makewebtask