July 9, 2009 at 3:04 am
[p]
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
[/p]
Vivek Shukla - MCTS SQL Server 2008
July 9, 2009 at 7:45 am
-- You can't be late until you show up.
July 9, 2009 at 7:45 am
-- You can't be late until you show up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply