Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLCMD won’t launch from command line or sql job Expand / Collapse
Author
Message
Posted Friday, April 12, 2013 3:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:22 PM
Points: 161, Visits: 644
SQLCMD won’t launch from command line or sql job. But the .exe in the binn folder launches fine. Getting the error cannot find the specified file in the (cmdExec) sql job. Same script works fine on other servers using same agent service account. This is SQL Server 2005 on Win Server 2003.

Any ideas would be appreciated.
Post #1441622
Posted Friday, April 12, 2013 5:33 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 3:18 AM
Points: 796, Visits: 2,353
do you have the sqlcmd.exe folder in the %path% environment variable? If not, add it, or try using the full path
Post #1441643
Posted Friday, April 12, 2013 6:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:22 PM
Points: 161, Visits: 644
adb2303 (4/12/2013)
do you have the sqlcmd.exe folder in the %path% environment variable? If not, add it, or try using the full path


It was in there, but I re-added it to the end of the path and it worked. Thanks!
Post #1441657
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse