Hi - I have a Web Assistant job t

[JohnBates]

Hi -
I have a Web Assistant job that generates an html page at specified intervals. As a simple process, this works really well.

The problem is that the web page must be output to a server that runs SQL Server (at least that seems to be the case).

But I need to get the html doc onto my web server where all the other Intranet pages reside.

Problem: The Web server machine is not a SQL Server machine.

I want to add a second Step to the job that will copy the html doc over to my web server.

Question: Is this doable? Will the fact that the web server is not configured as a SQL Server prevent the SQL Server/Web Assistant job from being able to copy the file to the non-SQL Server machine?

Can I accomplish this via T-SQL ?

I hope I have explained what I need to do.


Thanks, john

 

[tlbroadbent]

The Web Page creation Job runs under SQL Agent control. The SQL Agent account must be a domain account and have permission to write to the web server folder. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.