ccarrack
asked on
SQL Maintence Plans Not Running
Hi There,
I've got an SQL maintence plan that runs a database backup job and a database integrity check. These jobs have both started to fail and i can't figure out why. When i go into job history and have detailed history i find both jobs with this error message.
Executed as user: MIRAMAR\sqlserver. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
--
When i look in the event logs i recieve this warning for the failed backup job
Event Type: Warning
Event Source: SQLAgent$CARESYS
Event Category: Job Engine
Event ID: 208
Date: 09/11/2006
Time: 11:02:52
User: N/A
Computer: DC03
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'CareSys Databases'' (0x94A0D57F156CBF44AA2AAD4
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
--
And this warning for the failed integrity job
Event Type: Warning
Event Source: SQLAgent$CARESYS
Event Category: Job Engine
Event ID: 208
Date: 09/11/2006
Time: 12:09:29
User: N/A
Computer: DC03
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan 'CareSys Databases'' (0x7F6E3ECE3941E24EA29D0A4
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
--
Please help me as it is driving me up the wall
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.