After migration sql 2000 jobs it cannot be changed

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

After migration sql 2000 jobs it cannot be changed

Author

Topic

yash8506
Starting Member

6 Posts

Posted - 2009-06-23 : 16:23:49

I am migration sql server to new server with all jobs and DTS.DTS migration is successful but job cannot be changed to other server.
It comes with error "Job cannot be changed They originated from MSX server"

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2009-06-29 : 14:41:50

update the "originating_server" column within sysjobs in database msdb to reflect the new server name. I've done this many times in the past without issue.

i.e. - select * from sysjobs
update sysjobs set originating_server = new_server_name where originating_server = old_server_name

Terry

-- Procrastinate now!

yash8506
Starting Member

6 Posts

Posted - 2009-06-30 : 08:15:19

Thanks for the reply.

I was able to solve issue with same reason with same solution.I really appreciate the way you took initiative.

Thanks,
Yashwant

quote:
Originally posted by tosscrosby

update the "originating_server" column within sysjobs in database msdb to reflect the new server name. I've done this many times in the past without issue.

i.e. - select * from sysjobs
update sysjobs set originating_server = new_server_name where originating_server = old_server_name

Terry

-- Procrastinate now!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources