November 8, 2001 at 5:44 pm
hello all,
does anyone know how to script a web task that you have created. when you use the web assistant wizard, it gives you an option to script the job there. what if you would like to transfer this task to another machine but you forgot to save the scripting file at the end of the wizard.
thanks
M
November 8, 2001 at 7:18 pm
I havent tried it, but Im pretty sure it's all stored in tables in msdb. Probably can just DTS the rows over. I'll see if there isnt any easier way though.
Andy
November 12, 2001 at 10:19 pm
thats what I thought initially. but I couldnt find anytable except for mswebtasks table in msdb. but this table still does not contain the script to recreate the web task.
there might be another table, please let me know if you can find out or know how.
many thanks for replying.
Michael.
November 13, 2001 at 6:01 am
Doesnt seem to be possible. If you look at the sp_runwebtask it just hands it off to an extended proc that's in a dll. The data in the wparams looks to be binary, no sense to be made out of that! I haven't tried profiling, that might help some. Looks like the best bet is to save the script when you create it. Perhaps some enterprising person has deciphered the binary col?
Andy
November 14, 2001 at 4:30 pm
thats what I found out as well about wparam in the mswebtask table, knew about the DLL being called within sp_makewebtask. well at least someone else thinks its not possible too.
many thanks for helping Andy.
regards
Michael.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply