Post reply

Maintenance cleanup task 0k button grayed out

  • February 29, 2012 at 9:28 am

    #265363

    Recently added a new maintenance cleanup task to an instance (SQL Server 2008). While the task worked I decided that I wanted to reduce the number of files retained. While attempting to change the plan - I noticed the ok button was grayed out. After making the changes to the plan, the ok button was still grayed out, and my changes could not be saved.

    Note that this was a standalone, it was not coupled with a backup task. I have not attempted to delete the cleanup task. Are there any suggestions or know issues with this?

    Any comments / urls are appreciated - thank you.

  • March 5, 2012 at 8:27 am

    #1454822

    While I was not able to resolve - what I did as a work around - was to delete the job and re-create with the revised bak files I wanted retained. Couldn't help but notice that when maintenance cleanup was part of another job (with another task - i.e. backup), that you could modifiy a maintenance cleanup task.

    Even with the new job however - I was not able to modify. That's it... Any additional comments are welcome.

    Thanks.

  • March 5, 2012 at 8:54 am

    #1454845

    Slightly confused.

    The maintenance task should be in an SSIS/Maintenance plan package. It isn't a job. The job would be the item that schedules and runs the package/plan.

    Also, what changes did you make?

    I created a plan with only the Maintenance Task, saved it, ran it, then went in and made changes. Worked fine for me.

  • March 8, 2012 at 7:24 am

    #1456518

    When I've had things like this happen to me in the past it's usually been caused by a dialogue box that has popped up behind the main window and is awaiting input. Might be worth minimising boxes and seeing if anything becomes apparent.

    This is a high-class Bureau-de-Change.

  • May 9, 2013 at 11:28 am

    #1613935

    This is what worked for me - SQL 2012: maintenance plan - properties of plan, properties of task opens properties window on the right. Was able to change settings here, when I was not able to change it in the graphical task itself.

  • March 3, 2015 at 8:23 am

    #1781371

    Thanks for the reply, @richardstern, that worked for me. 🙂

  • June 3, 2015 at 12:58 pm

    #1802784

    This is an old thread, but what worked for me was editing the task name for some reason enabled the OK button.

  • December 14, 2015 at 10:01 am

    #1845863

    Renaming the Maintenance Plan helped me too. Grrrrrrazy ...

  • April 26, 2018 at 9:50 am

    #1988374

    Include star in file extensin:  worked for me

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply