Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jbates
Starting Member
9 Posts |
Posted - 2001-10-21 : 22:03:32
|
Hi SQL Pros - OK I'm not very experienced in SQL Server yet... thought I should warn you :)I use SQL Server 7 and NT 4.I used the Web Publishing wizard to generate an html page. Scheduled it to run at a certain interval - works well.Problem: The page gets written to the SQL Server server. I have had no luck in configurinmg the web task job to write the htm file to the Web server, where it really needs to be.So, I would like to add a Second Step to the job to copy the .htm file to my web server (which is not running SQL Server). Of course the files' name is always the same.Should I use the operating system command (cmdExec) or is it better to use VB Script....?Any ideas and especially tips on what the code should be will be very helpful.Thanks, John |
|
|
|
|