Hi All,
Sql server 7

I have webassistant job that are running every one minute.
they run sometimes and sometimes they fail.
the error message in job history is

error no 16821
SQL Web Assistant: Could not open the output file.

Pls suggest.

TIA
Adil

Does IIS grab the webpage?
If it does then it is grabbing it exclusively and therefore you cannot
overwrite.
I do not know a way around it.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"haseeb" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi
Thanks for ur Reply

Web Assistant DTS job which we have created will select
data from a particular table ABC and displays in a html
page, this will be in every interval of 1 minute. and the
DTS job gets refreshed every 1 minute.

pls suggest

TIA

Hi,
thnx for reply

the Web Assistant DTS job selects data from a table and
displays it in a html page, this will be in every interval
of 1 minute. and the DTS job gets refreshed every 1
minute.


TIA

---Original Message-----

Are you using the webpage though? Is IIS grabbing it perhaps?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"haseeb" <anonymous (AT) discussions (DOT) microsoft.com> wrote