Post reply

Cannot delete maintenance plan created by former employee

  • October 5, 2007 at 10:16 am

    #118949

    I know how to delete sub plans and jobs from the tables in msdb. However, even having done that, there are two maintenance plans that still display in the Management Studio tree. There were created by a former employee whose account (in Windows) has just now been deactivated. I cannot delete them with my account (even though I'm sysadmin level).

    Does anybody have a clue how to delete these and stop them from displaying?

    Thanks,

    Brent

  • October 5, 2007 at 10:38 am

    #739629

    If you have the Local Admin rights on your server machine and you are using windows login to connect to the sql server you should be able to delete the maintanence jobs.

    if you already have tried to delete them then try refreshing the server instance and check.

    Regards,

    Sathya

  • October 5, 2007 at 11:29 am

    #739645

    I currently have domain admin rights and am sysadmin in Sql Server.

  • October 5, 2007 at 11:32 am

    #739648

    I think I was in the same case before. I had to use SSIS UI to delete a package because normal DB Engine connection would not do it.


    * Noel

Viewing 4 posts - 1 through 3 (of 3 total)

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