Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_runwebtask

Status
Not open for further replies.
glewis1636

glewis1636

Programmer
Apr 26, 2004
39
0
0
US
I have created several webtasks. One of them has just stopped working. When I try to execute it in query analyzer using sp_runwebtask, i get the following error.

Server: Msg 16805, Level 11, State 1, Procedure sp_runwebtask, Line 26
SQL Web Assistant: Could not execute the SQL statement.

Not very helpful.
Any ideas?
 
Sort by date Sort by votes
Setup SQL Profiler and see what it reports.

Have the tables or columns that the web task is looking at changed any?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top