December 10, 2003 at 11:14 am
I have a 2000 Server running SQL Server 2000. I set up a DB Maintenance plan and scheduled it to run in SQL Server Agent. When I attempt to run it the job fails. Here are the messages I am getting:
From Application log:
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:12/10/2003
Time:9:38:20 AM
User:N/A
Computer:DBSERVER1
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0x000A550B80768141B753ABDB86800E2E) - Status: Failed - Invoked on: 2003-12-10 09:38:12 - Message: The job failed. The Job was invoked by User SA. The last step to run was step 1 (Step 1).
From job history:
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Any help would be appreciated.
December 10, 2003 at 11:58 am
Nevermind, I found my answer in an article by Andy Warren "SQL Maintenance Plans - Under the Covers!"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply