July 9, 2009 at 2:40 am
Hi guys
Backup Jobs created by maintenace task runs successfully but it generates following error message.
"Executed as user: domain\user. 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
Vivek Shukla - MCTS SQL Server 2008
July 9, 2009 at 2:46 am
Make sure you the account(job owner) with which the jobs are running has full access/sysadmin rights or change the owner to sa & then run the job.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 4:31 am
Check if the user has sufficient privileges to exec the jobs.
Check if he has these roles
# SQLAgentUserRole
# SQLAgentReaderRole
# SQLAgentOperatorRole
Tanx 😀
July 9, 2009 at 5:43 am
Did you change the service account w/o using CM? Make sure the path to which you are backing up, the service account has access to it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply