November 27, 2008 at 5:02 am
Hi,
I had a SQL Server 2000 SP3a running a scheduled job below:
EXEC sp_runwebtask @procname = N'FMS Stats'
We have now migrated this database to a SQL Server 2005 server and I am trying to schedule and run the process as before. When I try to run this process i get the following error...
Msg 208, Level 11, State 1, Line 0
[Microsoft][SQL Native Client][SQL Server]Invalid object name 'msdb..mswebtasks'.
Msg 16805, Level 11, State 1, Procedure sp_runwebtask, Line 33
SQL Web Assistant: Could not execute the SQL statement.
I understand that sp_runwebtask should not be run with SQL Server 2005 and hence my error message. However, I don't seem to be able to find out what has replaced this in SQL Server 2005? I have enabled Web Assistant from the Surface Area Configuration.
Any help please?
November 27, 2008 at 6:26 pm
This is from books online. It is still available in 2005, but it looks like it is not in 2008.
sp_runwebtask is retained for backward compatibility. New Web pages are more easily created and managed using Microsoft SQL Server 2005 Reporting Services (SSRS).
To execute sp_runwebtask you must be a member of the public role.
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
November 28, 2008 at 2:58 am
Thanks Ken.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply