Post reply

Can't delete SQL Server Agent job that was created by a Maintenance Plan

  • April 29, 2009 at 7:52 am

    #204071

    I created a simple Maintenance Plan to backup a database. I no longer needed the plan, so I deleted it. I assumed it would also delete the SQL Server Agent job that it had created. It did not, so when I try to delete the job I get: Attempt to retrieve data for object failed for server 'grcedata00'. The Job 'MaintenancePlan.SubPlan_1' does not exist on the server.

  • April 29, 2009 at 8:12 am

    #985944

    Keith Thomas (4/29/2009)

    I created a simple Maintenance Plan to backup a database. I no longer needed the plan, so I deleted it. I assumed it would also delete the SQL Server Agent job that it had created. It did not, so when I try to delete the job I get: Attempt to retrieve data for object failed for server 'grcedata00'. The Job 'MaintenancePlan.SubPlan_1' does not exist on the server.

    When you deleted the maintenace plan, the job most likely has been deleted as well, only SSMS hasn't refreshed the list of jobs yet. That's the reason for the error, you try to delete something which no longer exists.

    [font="Verdana"]Markus Bohse[/font]

  • April 29, 2009 at 8:31 am

    #985969

    Thanks that was it. Should have thought of that - been burned before by not refreshing.

    Thanks

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

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