SQL Server Performance

SQL Server Jobs

Discussion in 'General DBA Questions' started by viv, Jul 9, 2009.

  1. viv New Member

    Hi guys

    Backup Jobs created by maintenace task runs successfully but it generates following error message.

    "Executed as user: domainuser. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."

    checks carried out:

    1. When looked for these jobs in model.dbo.sysdbmaintplan_history table they doen't appear there.

    2. Also, changed scheduled time at which these jobs run just in case if other jobs were trying to use sqlmaint.exe at the same time which cause some locking issues and i get the same results.

    3. Created all jobs from scratch and its still not working.

    Any help would be much appreciated guys.

    Thanks in advance.

    Vivek

  2. rayala.thulasi New Member

    hi vivek,
    while creating the maintainance paln for backup job you need to login with DBO role or sysadmin role to create the plan.if your trying to execute .exe file make sure that particular login is having dbo role or not? are you trying to create maintance plan from Enterprize manager or some otherway?
    Thanks,
    Thulasi.
  3. viv New Member

    Hi Thulasi
    Thanks for you replay. However, i have managed to resolved this issue in the mean time.
    The cause of the error was an account with no sysadmin rights.
    Thanks a lot for you help though.
    Regards,
    Vivek

Share This Page