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: Monday, July 7, 2014 11:03 AM
Points: 161, Visits: 660
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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:49 AM
Points: 811, Visits: 2,418
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: Monday, July 7, 2014 11:03 AM
Points: 161, Visits: 660
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