While working with maintenance plans, you may come accross to following error message.
Server: Msg 22029, Level 16, State 1, Line 0
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