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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy