Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2005-11-10 : 10:23:14
|
| Hi,I am getting wierd error on the database maintenance plan. it runs the job but it ends in error and in history says that the [SQLSTATE 42000] (Error 22029)Unable to open Step output file. The step failed.what could be the problem!!thanks |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2005-11-10 : 12:52:16
|
| One of the steps in your maintenance plan has a log file with an invalid path.Check the path info and remember that the path is from the servers point of view and not yours."God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-12 : 22:04:20
|
| Also, make sure the account running the plans actually has permissions to write files to that directory.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2006-08-23 : 01:38:19
|
even I faced the same issue where the job log file creation failed and hence the next steps failed, and I found that the drive was corrupt where it was supposed to put the log file.  - = Cracky DBA = -http://www.geocities.com/gvphubli/ |
|
|
|
|
|
|
unable to open set up file