All Maintenance Jobs On New Servers Failing

Hi all,

I've just set up 2 new SQL 7.0 servers, and my new maintenance jobs - backups, optimisations, consistency check jobs etc - are all mysteriously failing. I've created them both with the Maintenance Wizard, and again by hand. I've attempted manual and scheduled runs. All to no avail. Nor do they populate the sysmainthistory table, although they're configured to do so. The mystery is that we have successfully installed some user DTS processes, and THEIR jobs work. In order to resolve the problem, I've:

(1) ensured the Agent service is running;

(2) ensured adequate space on the drive etc;

(3) verified that sqlmaint.exe exists in Mssqlinn;

(4) unchecked the 'attempt to repair minor errors' box (I read this was a known cause of the problem);

I've got some clues to go on, but nothing conclusive;

'sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.'

Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe
failed. [SQLSTATE 42000] (Error 22029). The step
failed.

Additionally, both servers hold databases that I imported from another server-INCLUDING the msdb, and BOTH have the same problems and same error messages. This cannot be a coincidence.


Anyone have any ideas?


Thanks in advance,


JB.