:::: MENU ::::

sqlmaint.exe failed.

  • Feb 21 / 2009
  • 0
dbDigger, Maintenance plans

sqlmaint.exe failed.

While working with maintenance plans, you may come accross to following error message.

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.

Reason for this error is that user login for that specific maintenance plan is lacking execute privileges on sqlmaint.exe. To remove the error grant execute permission to that user on xp_sqlmaint system stored procedure in master database. For example to grant execute permission on xp_sqlmaint to user ‘Test’ use following command

USE master
GO

GRANT EXECUTE ON xp_sqlmaint TO Test
GO
Consult us to explore the Databases. Contact us