Hi Experts, I need help in finding out why this error occurs on our sqlserver 2000 db. This MP runs every week on Sunday night and it has been failing for a couple of weekes already.
Optimizations Job for DB Maintenance Plan 'System DB Maintenance Plan' Step 1 Run date/time - 20070715/01:00:03 Run duration in hours:minutes:seconds - 00:01:09 Executed as user: PERVIEW2001\SQLAdmin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Optimizations Job for DB Maintenance Plan 'System DB Maintenance Plan' (Job outcome) Run date/time - 20070722/01:00:03 Run duration in hours:minutes:seconds - 00:01:17 The job failed. The Job was invoked by Schedule 95 (Schedule 1). The last step to run was step 1 (Step 1).
How can I debug this error?