bridgewater
Programmer
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:
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
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
Any suggestions on what the problem might be?
Thanks