Re: Warning: cannot write logfile

I am using SQL 2000. I changed the user to SA and it worked.

Thanks for your advice.

"Russell Fields" wrote:

Monica,

Under what account is this job running? And what version of SQL Server?

If the account is not a sysadmin, then the SQL Agent Proxy account will be
used. (In a SQL Server 2000 server that was upgraded to SQL Server 2005, you
may see a proxy named UpgradedProxyAccount that uses UpgradedProxy.)

If this account does not have rights to write to the directory, the job will
run, but you will get the error.

If I remember correctly, a non-sysadmin in SQL Server 2000 cannot write to a
file. (But test it and see.) If that is the case, another option is to
check Append Output to Step History, which would allow you to see the output
using Enterprise Manager, going to the Job Step Advanced tab and pressing
View.

RLF

"Monica" <Monica@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:039D65F6-B272-4555-BBA3-6CD1A7B09D59@xxxxxxxxxxxxxxxx
Hello,

I am scheduling a simple job to run a query. I want the result of that
query
written to a text file.
When I am scheduling the job, in the step section I am creating a step of
type "Transact-SQL Script (TSQL)" where I define the query. In the
advanced
tab of the Step section there is an option to put an output file and there
I
put the path where I want the text file created.
When I run the job, it runs successfuly but the file is not created. I get
a
Warning:cannot write logfile message.

Can anyone give any ideas to fix this?




.

Relevant Pages

  • Re: How to populate a list box based on user input?
    ... associated with that account pop up in a list box. ... click "View" and a query come up showing all those orders on separate ... I get stuck on what the SQL should look like in the Control Source ... Private Sub txtAccountNo_AfterUpdate ...
    (microsoft.public.access.modulesdaovba)
  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" ...
    (comp.databases.oracle.server)
  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ...
    (microsoft.public.win32.programmer.wmi)