Tony Rogerson MCP, SQL Server MVP
Torver Computer Consultants Ltd.
www.sql-server.co.uk ( Under construction - still ! )
Quote:> I am running SQL Server 7.0 and i'm trying to run a ComdExec job which
> outputs to a file on a drive that is mapped to another NT Server
> machine. When I execute the command using "run" off the start menu it
> works fine. However when I run it inside the SQL Server Agent as a it
> always fails. Do I have to restart something so that the Server Agent
> can see the mapped drive?? What am I doing wrong??? Has anyone else had
> this problem?
Besides making sure the account has rights, use a UNC name rather thanQuote:>I am running SQL Server 7.0 and i'm trying to run a ComdExec job which
>outputs to a file on a drive that is mapped to another NT Server
I have a job in SQL Server 2000. The job selects data from
the SQL server(using a query) and writes it to a .dbf file
on a network drive.
When I start the job / schedule it, the job history shows
that it has run successfully but it does not create or
update the .dbf file. However if I write it to a local
disk it succeeds. FYI - in the job history , in step
details it shows "Could not open step output file. Step
Any help appreciated.
Thanks in advance.