| Event Information | According To Microsoft:
CAUSE:
The Web task name specified does not exist in msdb..mswebtasks. Web tasks are created by sp_makewebtask. If the @datachg parameter was specified for sp_makewebtask, triggers are created on the specified table.
This error may occur if you specify a Web task that does not exist when you execute sp_runwebtask or sp_dropwebtask. It may also occur when you modify a table that has one of the triggers created by sp_makewebtask and the task referenced in those triggers no longer exists. One reason that tasks do not exist could be that the Web tasks were removed by some method other than sp_dropwebtask. They could also be missing due to a restore of msdb to a time when the web tasks do not exist.
Resolution:
Follow these steps:
1. Verify that the Web task name you specified is a valid Web task.
2. If you have manually removed Web task stored procedures or have manually removed rows from msdb..mswebtasks, you will have to complete the cleanup process by manually removing the triggers from the tables formerly referenced by the Web tasks. The proper way to remove Web tasks is to use sp_dropwebtask.
3. If the error is due to a restore of msdb, restore a version of msdb that contains the Web tasks. |
