Failed executing API: CreateProcess. [SQLSTATE 42000] (Error 22029).

[seekwall]

I am running SQL Server 2000 Standard Edition, Service Pack 3 on MS Windows Server 2003 Standard Edition.

I set up a maintenance plan using the 'Create a Maintenance Plan' wizard to run scheduled database and log backups. The jobs fail however with the following error in the job history...


Failed executing API: CreateProcess. [SQLSTATE 42000] (Error 22029). The step failed.


There seems to be very little help on the internet regarding this problem, the majority being conjecture and guesswork. The only article I could find in Microsoft was the following, which deals with the issue in SQL Server 7...

http://support.microsoft.com/support/kb/articles/Q246/8/15.ASP

I've also noticed that in Enterprise Manager, 'Database Maintenance Plans' isn't showing under 'Management', but you can view the individual 'Jobs' under 'SQL Server Agent'... which is obviously something to do with the issue.

Can anyone help ??

 

[seekwall]

Think I've solved it.

I believe the Sqlmaint.exe neds to be in this directory on the server...

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

It is currently here...

C:\sql2ksp3\x86\binn

Not sure whether this means that the Service Pack hasn't been installed properly or not tho !?!

 

[Glowworm27]

MIne was blowing up to, I had sqlmaint.exe in the folder but was an older version, I copied a newer version into that folder, and it works now. Hope this will help someone



George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips