Plan Maintenance will not execute

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Bitner (anonymous_at_discussions.microsoft.com)
Date: 07/15/04 

Date: Wed, 14 Jul 2004 19:55:44 -0700

My plan Maintenance to Optimize, TRN Backup and Reporting
has been running for several months. A few days ago, I
started getting the following in "View Job History":

"Executed as user: domain\Administrator. sqlmaint.exe
failed. [SQLSTATE 42000] (Error 22029). The step failed."

There is no log file created, even though I requested one,
which leads me to believe the Job never actually started.

The Windows 2000 Applications Log has the following:

"SQL Server Scheduled Job 'Optimizations Job for DB
Maintenance Plan 'Test 1''
(0x529723559D047845AB998AFF9BDA397F) - Status: Failed -
Invoked on: 2004-07-14 22:30:00 - Message: The job
failed. The Job was invoked by Schedule 42 (Schedule 1).
The last step to run was step 1 (Step 1)."

When I try and run the command in Query Analyzer, I get
the following:

"Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed."

The recovery model is "Bulk-Logged"

Does anyone have any Idea what has gone wrong in this
maintenance Plan?

Relevant Pages

  • Re: network administrator for 30 computers on SBS
    ... Keep in mind though you cannot plan ... and schedule your issues or problems. ... administrator here should something go wrong"? ... > Is there a rule of thumb out there regarding maintenance time for the box ...
    (microsoft.public.windows.server.sbs)
  • Re: Proper Leveling Techniques - Rescheduling to start later
    ... Start and Finish are what your schedule calls ... Baseline Start and Finish are your original starting plan ... otherwise to force the tasks to end up on certain dates - leveling has ... I don't know why you're so adament againt using SNET constraints in any ...
    (microsoft.public.project)
  • Re: Finish Date Auto Update
    ... I work for a door company who gives out ... want in that field and then they are always on schedule. ... > The check boxes you're referring to don't have any effect on that behavior - ... But if it deviates from the scheduled plan they MUST manually ...
    (microsoft.public.project)
  • Re: Finish Date Auto Update
    ... The engineers out doing the jobs are not project managers even though they may have supervisory duties on the job site. ... Project planning, managment, and monitoring is more appropriately the role of the supervisor's supervisor. ... want in that field and then they are always on schedule. ... But if it deviates from the scheduled plan they MUST manually ...
    (microsoft.public.project)
  • Re: Bring Past Planned Work Current
    ... How could it ever be possible to pull work that's behind schedule forward and NOT have the finish date change??? ... Unless the scope of the project changes so it essentially becomes a different project, the original baseline should be engraved in granite and never changed. ... The baseline is a fixed reference point for monitoring progress of actual against plan and is the sole source of information you have as to whether your plan as it is evolving once work is underway is on-time or within-budget. ... If work has been delayed so the current schedule shows you finishing 1 October, that unchanging baseline is your only record that your original plan called for you to finish 1 September and now you're a month late. ...
    (microsoft.public.project)