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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-19 : 07:06:26
|
| Prakash writes "Hi,We have SQL Server 2000 and Connect:Direct (Version 4.0) Installed on Windows 2000 Server SP4. We have a JOB in SQL Server, scheduled to run a MS DOS Batch file. This batch file has scripts to execute Connect:Direct commands.When I run this file in DOS Prompt, it works fine. We are getting error when we execute the same batch file in our JOB.Could you pls help us on this issue?Your early response would be highly appreciated." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-19 : 07:46:38
|
| Does the "user" that SQL Agent runs as have permission to run the BATch file (and whatever tasks the BATch file does)?Kristen |
 |
|
|
|
|
|
SQL Server JOB failed to execute Connect:Direct BAT file