June 13, 2007 at 12:37 pm
I can't seem to specify a server name as part of my Job Step Output File in SQL 2005, like I was able to do in SQL 2000. I'm only able to browse the actual Drive letters on the SQL server, when I define the job.
For example, I can specify \\myserver\SQLJobLogs\mytext.txt, but when the job runs, nothing is generated in \\myserver\SQLJobLogs as I would have expected. Yet, if I use a drive letter like D:\SQLJobLogs\mytext.txt and run the job, output is produced as expected, in D:\SQLJobLogs. Has anyone seen this before?
Any information would be greatly appreciated. Thanks!
June 14, 2007 at 6:53 am
Is the SQLJobLogs a share that the SQL Server Agent user has access to? Have you tried \\myserver\d$\SQLJobLogs\mytext.txt ?
The Redneck DBA
June 14, 2007 at 7:36 am
You should be able to .
In the advance properties of the job .For output file
put the UNC path .It should work.But first verify the UNC path is valid
Mike
June 14, 2007 at 8:42 am
I think it will access UNC path only if the SQL Server & SQL server Agent are running under a domain account.
Sachin
June 14, 2007 at 8:55 am
Agree with Sachin
A domain account with needed privileges to the share you intend to write to .
Mike
June 14, 2007 at 9:54 am
Ahh! When I changed SQL Server Agent to run as a domain account, it worked! Thanks all! -Phil-
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply