Sunday, August 5, 2018

Unable to open Step output file. The step failed

When you try to execute the job, The job will fail with error "Unable to open Step output file. The step failed"
In this case there is no error with the package. So we have to change the path in jobs under sql agent job.

For example if the job name is: Batch_price.

Here is the steps:

1. Double click on Batch_price in sql agent job. [i.e. job properties]
2. Go to steps.
3. Edit steps.
4.Click advanced option.
5.Change the path under output file as in image below or delete the path.
6. ok and run the job again.




2 comments:

  1. This was helpful in fixing a restore job that was failing due to original disk being deleted and path not correctly updated. Thanks a lot!

    ReplyDelete
  2. Thanks for the fix, it's been a nightmare.

    ReplyDelete