I am trying to run a batch file from a SQL Agent job. This batch file is a connection command and script file that will run. I can run the the actions straight from Command Prompt, but I need it to be fired from a SQL Agent job for the automation of it.
Every time I try to fire it off I get these errors:
"The system cannot find the file specified"
When I set the command up, I am using the GUI in the Jobs area and using the 'Open' button and then navigating to the proper file. I have also tried changing the Services from the NT user to a Local Admin user, but still had the same end result.