December 3, 2004 at 12:29 pm
On a SQL Server (2000, SP3), within DTS I am using the Execute Process Task to execute a Batch File. The DOS Batch File is located on a File Server and it is referenced in the Execute Process Task with a UNC Name. The DOS Batch File calls the DOS Sleep Function. This Process has been working for about a year until a couple of weeks ago when we swapped the SQL Servers and the File Servers (removed the old and installed the new servers.) Now, all of a sudden when the Sleep Command is called it is returning the following:
"N:\fidata\ftp\Lehman\ftp>sleep 600
'sleep' is not recognized as an internal or external command, operable program or batch file."
The Sleep Command is on the SQL Server and the File Server. I can go to each machine and execute the Sleep Command from the command line. Do I need to do something else to make the Batch File recognized the Sleep Command? Do I need to use the Path Program to set the program search path? (I do not know if the Path Program was set up on the old SQL Server and File Server.)
Also, since the Batch File is called from the SQL Server but located on the File Server, where is it (the Batch File) actually being executed, on the SQL Server or File Server? Who's memory space (SQL Server or File Server) is the Batch File being executed in?
Thanks in advance, Kevin
December 3, 2004 at 2:32 pm
Kevin,
I think everything is in the SQL Server server.
There is a user path and system path. It all depends on what user accounts are the SQL Server services (MSSQLServer and SQL Agent) are using. I believe in your case, when you moved servers - you changed (or forgot to change) the service accounts.
Let us know...
Regards,
JA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply