SQL Server Performance Forum – Threads Archive
problem in executing optimization job
I have created an optimization schedule for a database. But the job is failed by reporting the following error. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. can any body help in this regard? ThanksNarasimha reddy
I don’t think we can conclude anything based on this error…
Check the maintenance plan output/report file for more details..and Maintenance plan history…
Check the sql error log too for any errors during this time…
Make sure you don’t repair your db in this optimization job because db has change to single user mode to repair…
if you are running backups in this job… make sure you have enough space for backups… Mohammed U.
Look at application / system logs / error logs / agent logs this is a very generic error message raised by ODBC adn does not indicate issues.
To be specific look at the database maintenance plan log for more information.
http://www.sql-server-performance.com/ak_inside_sql_server_maintenance_plans.asp
http://www.sql-server-performance.com/sql_server_maintenance.asp fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>