When you say that they run them manually and they work, are you running them on your local machine or on the server via RDP/console? You will want to check that the server has the ODBC DSN and driver.
If that is not the issue, what is the environment? SQL Version, etc.
Lake Wylie, SC, USA