October 1, 2003 at 9:35 am
Ok, I've seen this before. I've recently moved my SQL 2000 database(s) to a new server which the same name retiring the old server. Everything works fine except jobs. DTS scheduled jobs, I had to fix however, cann't delete or change the jobs. Same with backups that I created. I cann't delete the scheduled jobs or modify them. If I create new ones than I get news ones added.
Error is 14274: Cannot add, update, or delete a job or its steps or schedules that originated from an MSX server.
October 1, 2003 at 10:20 am
Was the source server a MAster Server?
Try defecting the destination server with msdb.dbo.sp_msx_defect. If the destination server is already a target server, be carefull because all the MSX jobs will be deleted.
October 1, 2003 at 11:11 am
I'm not certain how to respond. I'm not using (or not intend to implement) Master / multiserver administration.
All jobs are running on this server. All DTS jobs are getting data from another server. The backups are also running on this server. There is no MASTER server (that I know of). This server (SQL) was moved to new hardware server Monday night. The old server was renamed to something else and this one renamed to original name. I did the SP_CHANGE_USERS_LOGIN trick and the SP_DROPSErver and SP_addserver trick.
quote:
Was the source server a MAster Server?Try defecting the destination server with msdb.dbo.sp_msx_defect. If the destination server is already a target server, be carefull because all the MSX jobs will be deleted.
Edited by - rgetsy on 10/01/2003 11:30:16 AM
October 1, 2003 at 11:48 am
Your original server name is stored in sysjobs table in msdb. Manually change it with new server name and you will be fine.
October 1, 2003 at 12:01 pm
IT WORKED! Thanks.
quote:
Your original server name is stored in sysjobs table in msdb. Manually change it with new server name and you will be fine.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply