Posted by Erland Sommarskog on 03/26/07 21:31

Amber (guxiaobo1982@gmail.com) writes:
> 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

Where is SQL Server installed? If it's installed on C:, the CD command
which change the default directory on the E drive, but it will not
change the drive. You need to add this line to the file:

E:

> 5. Save the job and run it, Management Studio tells the job faild, but
> did not tell an error message.

Find the job under SQL Server Agent, right-click and select View History.
For each job execution there is a cross, click on this to expand the
job steps. The read the output for the individual steps.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Bulk insert error -- "Unknown version of format file"
• Prev in forum: Re: SQL 2005 automatically partitioning?
• Thread view: Re: SQLAgent 2005 SP1 failed to run .bat file.

[Reply to this message]