MSX Server

• Taj

  Mr or Mrs. 500

  Points: 596

  More actions

  November 12, 2004 at 12:23 pm

  #162804

  I am currently handling 3 sql servers. Test, Development and Production. Recently I transferred a Database from production to Test using DTS. Database itself was a play database. I use the copy all data and objects option. It also transferred some of the jobs I had on production server in the database. Now on the test server when I try to delete the jobs it tells me

  "Cannot delete, update, insert any jobs originated from MSX server" 

  So I went and deleted the jobs from production and refreshed the database and server. On test server it still would not let me delete the jobs.

  Here is the funny thing. Jobs were part of the database maintenance plans. Test server would let me delete the plans but not the jobs.

  So million $$ question is how to delete these jobs?

  Any suugesstion will be very much appreciated.

   

  
  Tajammal Butt

• Johan Bijnens

  SSC Guru

  Points: 135368

  More actions

  November 12, 2004 at 1:31 pm

  #530004

  mu 2ct

  maybe edit the jobs and set 'target' to the local (test) server.

  Then delete the jobs.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me