Post reply

sp_runwebtask

  • July 23, 2007 at 7:54 am

    #173861

    I get this error while try using sp_runwebtask:

    SQL Web Assistant: Web task not found. Verify the name of the task for possible errors.

    The syntax is this one:

    sp_runwebtask @procname = 'MYHTML2', @outputfile = 'C:\Web\test.html'

    The web task MYHTML2 exists and was created with sp_makewebtask, and works fine.

    Any ideas?

  • July 24, 2007 at 8:16 am

    #721932

    Just one idea right now... Was the web task created with sp_makewebtask using parameter @whentype=5?

  • July 25, 2007 at 2:58 am

    #722191

    no, I used the 8 (now, and recurrent).

    But I found a workaround creating a Job and putting inside the query with sp_makewebtask.

    The Job runs on a schedule, that is what I wanted to do with sp_runwebtask.

    Thanks for answering!

  • July 25, 2007 at 3:09 am

    #722193

    Yes, this will work. However, you can't use it anywhere where a simple user (not admin) should start it manually - sp_makewebtask requires sysadmin role. That's also the only situation where we use runwebtask: reports that can be started by a user from intranet.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply