|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > SQL Agent/Jobs does not see locally mapped drives ..
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Agent/Jobs does not see locally mapped drives ..
|
|
|
| SQL Agent/Jobs does not see locally mapped drives, hence
fails packages although package runs fine individually
SQL Gurus,
SQL Job not able to see the mapped drives on the local
machine, however the packages which create logs on the
mapped shared drive works fine from DTS. Why is that the
same package when scheduled to run from the job section
fails the package as it is not able to see the H drive
(mapped drive).
Please advice.
| |
| Sue Hoegemeier 2002-06-22, 8:35 pm |
| Because a mapped drive is dependent upon the Windows
account. When you run it manually, you have a mapped drive
but when run as a job, the account for SQL Agent has no
knowledge of your mapped drives.
It's recommended to use a UNC path rather than mapped
network drives.
-Sue
On Wed, 19 Jun 2002 08:19:23 -0700, "kk"
<kavidha.suyamburajan@zurichna.com> wrote:
>SQL Agent/Jobs does not see locally mapped drives, hence
>fails packages although package runs fine individually
>
>SQL Gurus,
>
>SQL Job not able to see the mapped drives on the local
>machine, however the packages which create logs on the
>mapped shared drive works fine from DTS. Why is that the
>same package when scheduled to run from the job section
>fails the package as it is not able to see the H drive
>(mapped drive).
>
>Please advice.
| |
| Gautam Udeshi 2002-06-27, 3:25 pm |
| Make sure the account starting SQL Server Agent is a domain account with
permissions on all dthe drives.
For more information check out
http://support.microsoft.com/defaul...b;en-us;Q269074
--------------------
| Content-Class: urn:content-classes:message
| From: "kk" <kavidha.suyamburajan@zurichna.com>
| Sender: "kk" <kavidha.suyamburajan@zurichna.com>
| Subject: SQL Agent/Jobs does not see locally mapped drives ..
| Date: Wed, 19 Jun 2002 08:19:23 -0700
| Lines: 13
| Message-ID: < e70a01c217a4$b1203ab0$a4e62ecf
@tkmsftngxa06>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcIXpLEgxehcMkUNRwqdK2c6HVt1SQ
==
| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa08
| Xref: cpmsftngxa08 microsoft.public.sqlserver.server:215372
| NNTP-Posting-Host: TKMSFTNGXA06 10.201.232.165
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| SQL Agent/Jobs does not see locally mapped drives, hence
| fails packages although package runs fine individually
|
| SQL Gurus,
|
| SQL Job not able to see the mapped drives on the local
| machine, however the packages which create logs on the
| mapped shared drive works fine from DTS. Why is that the
| same package when scheduled to run from the job section
| fails the package as it is not able to see the H drive
| (mapped drive).
|
| Please advice.
|
Regards
Gautam Udeshi
Microsoft SQL Server Support
Of course, this posting wouldn't be complete without a nice, juicy
disclaimer from our lawyers: This posting is provided "AS IS" with no
warranties, and confers no rights. You assume all risk for your use. © 2001
Microsoft Corporation. All rights reserved.
| |
| Kurt Kauper 2002-06-27, 4:25 pm |
| Thank you Sue and this makes sense.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
|
|
|
|
|