Results 1 to 2 of 2

Thread: Orphaned Scheduled Jobs

  1. #1
    Join Date
    Mar 2003
    Posts
    7

    Orphaned Scheduled Jobs

    Had to rename a SQL 2000 box and now the scheduled maint jobs that were created under the previous name of the box cannot be deleted via EM. Can anyone offer help?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Delete them manually from sysmaintplan* tables in msdb.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •