CmdExec??? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

CmdExec???

Author

Topic

zishan876
Starting Member

4 Posts

Posted - 2009-02-12 : 12:03:25

Hi I can run the following in Command Line prompt
C:\salesforce.com\Apex\bin>process.bat "C:\salesforce.com\Apex\test\" databasewsExtractProcess

But when I place it in SQL Server Agent /jobs...
as C:\salesforce.com\Apex\bin\process.bat "C:\salesforce.com\Apex\test\" databasewsExtractProcess
It will not run???
Can some one please help me ... I have other stuff and they work fine like C:\salesforce.com\Apex\bin\ws.exe

Thanks

Thank You
Shan

revdnrdy
Posting Yak Master

220 Posts

Posted - 2009-02-12 : 12:14:22

Hello;

Can you please post the error you get when trying to run the code?
You should have a log file in management studio that you can look at.

This will help in determining your problem. Otherwise all we may be able to offer is a WAG.

r&r

zishan876
Starting Member

4 Posts

Posted - 2009-02-12 : 12:33:39

Hi Thank you for replying back.. where do I find that error log.. When I go into Job History.. I find this error:
The system cannot find the path specified. Process Exit Code 1. The step failed.

Does that help?

Thank You
Shan

zishan876
Starting Member

4 Posts

Posted - 2009-02-13 : 09:17:41

anyone?? Please help

Thank You
Shan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources