Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL2005 Maintenace Plans errors

Status
Not open for further replies.

bridgewater

Programmer
Feb 16, 2007
1
GB
Hi all,

I am having some problems with backups on my SQL 2005 server. I have created a maintenance plan to back up the databases, but they are not running.

When I look in the SQL agent error log I get the following errors:
Code:
Message
[298] SQLServer Error: 208, Invalid object name 'msdb.dbo.agent_datetime'. [SQLSTATE 42S02]

[298] SQLServer Error: 14262, The specified @job_id ('459E7BB1-0930-46D2-A4D1-980152833109') does not exist. [SQLSTATE 42000]

Message
[000] Unable to retrieve steps for job Test Plan
The function 'msdb.dbo.agent_datetime' is present in the msdb database. i am running the Maintenace plan under the Local admin login.

Any suggestions on what the problem might be?

Thanks

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top