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 |
|
kpsreenath
Yak Posting Veteran
52 Posts |
 Posted - 2006-02-21 : 12:32:52
|
| We did a migration of some databases from the production to the test.One of the DTS packages is calling a stored procedure sp_runwebtask @procname = 'abc'sp_runwebtask creates a html document and then there is a sp_smtp_sendmail which sends the mail with the attachment created in the runwebtask.proc abc has a query which is working fine in productionsp_runwebtask is working fine in the production, but not in the staging environment.I put a trace to see where exactly its erroring out.Internally it calls a extended stored procedure xp_runwebtask which calls the xpweb70.dll. I can see that this DLL is present in the staging environment. Googled for the error message, but didnt yeild any good pointers.Pls help, its urgentThe correct error message is Server: Msg 16882, Level 11, State 1, Procedure sp_runwebtask, Line 26SQL Web Assistant: Web task not found. Verify the name of the task for possible errors.Error: @attachments file "E:\xxx.htm" does not existServer: Msg 50000, Level 16, State 1, Procedure sp_smtp_sendmail, Line 41Sending message using xp_smtp_sendmail failedThanks in advanceSreenath |
|
|
kpsreenath
Yak Posting Veteran
52 Posts |
Posted - 2006-02-21 : 14:47:12
|
| Got a work around of using sp_makewebtask instead of sp_runwebtask.But still I would like to know why the sp_runwebtask is not workingThanksSreenath |
 |
|
|
|
|
|
SP_Runwebtask Error 16882 Web task not found