June 30, 2004 at 3:56 pm
(Sorry but I have posted this again with different wording to make it easier to understand.)
I have some DTS Scheduled Jobs that have been running since December 2003. They run with the Domain Sqlagent Account. Now all of a sudden on Tuesday (06/29) they are not running as scheduled jobs. I am able to directly run the DTS Packages successfully from within SQL Server EM.
1) The DTS Package calls an Execute Process Task Step which calls a batch file via a UNC Path Name. Inside this batch file the following DOS Statement is executed:
pushd \\Servername\FixedInc\fidata\ftp\lehman\ftp
2) The View Job History Error Message:
C:\Program Files\Common Files\System\Mapi\1033\NT>pushd \\Servername\FixedInc\fidata\ftp\lehman\ftp' ' is an invalid current directory path. UNC paths are not supported.
Why all of a sudden would the Jobs start complaining about UNC Paths? Our Network Group assures me that no changes have been made to the servers, network or sqlagent account.
July 1, 2004 at 4:49 am
There might have been a change to the command extensions which prevents pushd from using UNC paths. Check out the link from http://www.ss64.com/nt/pushd.html
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply