Posted by Amber on 03/26/07 12:53

Following is our test steps.
1. Create directory E:\firefly in E:.
2. Create a test file a.txt in E:\firefly.
3. Create E:\firefly\test.bat file with the following commands:
cd E:\firefly
copy a.txt b.txt
4. Create a new job in SQL Server Management Studio with only one
step, this only step's command
type is set to "Operating system(CmdExec)", and click the "Open"
button to choose E:\firefly\test.bat
file, then the commands in test.bat are copyed to the command editor.
5. Save the job and run it, Management Studio tells the job faild, but
did not tell an error message.

If I only use the following command :copy E:\firefl\a.txt E\firefly
\b.txt, and SQLAgent can
run the command successfully via the job.

The real functionality of our job is to backup database to a file,
then use our source control tool's
command line tool to submit the backup file to the server.

[Back to original message]