February 27, 2004 at 4:18 am
Is there an easier way to refer to a path, such as:
\\servername\f$\folder 1\folder 2\folder n\application.exe
Can I somehow give this path a "logical" name so that I can refer to that, instead of the long path everytime I use it in a job ?
I have a server that points to other servers via jobs (enterprise mgr) and the jobs dont seem to like the path names (ie. blanks). Using quotes around the path doesnt work.
Thanks for any help.
February 27, 2004 at 4:23 am
You can map a drive, just have to make sure it's mapped under the agent account.
February 27, 2004 at 4:27 am
I've mapped drives before, but how do I make sure its under the agent account ?
Sorry for being so ignorant, only been a "dba" for a few months.
Thanks
February 27, 2004 at 6:46 am
Login using the SQL Server Agent account, and map a drive to the location (being sure to set the checkbox for Reconnect At Logon).
February 27, 2004 at 8:05 am
I am not sure that mapped drives will work because those setting are profile specific and the account is running as a service. sevices are not profile aware, that's the reason you need UNC paths
* Noel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply