Error 14274: Cannot add, update, or Delete

[CXO]

I am running windows 2000 server and MS SQL server 2000 standard.

I have recently renamed my servers and joined a different domain. Things are working well except that my maintenance plans had to be recreated and the when I try and delete old jobs under the SQL server Agent. it informs me that I cannot delete, update etc:

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX Server.

Any ideas on what I should do to resolve this

Christian Ormstrup

 

[JayKusch]

I am guessing that you changed the computer name during the rebuild.

This should help:

DECLARE @srv sysname
SET @srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @srv



Thanks

J. Kusch

 

[CXO]

thanks
do i run this from Query analyzer?

I treid it and it fails at the UPDATE sysjobs Line
Is it possible that there is a another function or same function as sysjobs with another name?

I could not find sysjobs anywhere.

thanks again
Chris Ormstrup

 

[JayKusch]

SysJobs is found in the MSDB database where all info on jobs are stored for the server. Did you replace the 'SERVERNAME' with your corrosponding server name as it stands today?

Thanks

J. Kusch

 

[SQLBill]

Run it from Query Analyzer, but add this to the BEGINNING of the script:

USE MSDB
GO



-SQLBill

 

[CXO]

Thanks

I see it there(msdb)

Should be OK now.

Will add:
USE MSDB
GO

Thanks again
CXO