dbTalk Databases Forums  

Can't delete SQL svr Agent jobs

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Can't delete SQL svr Agent jobs in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Parke
 
Posts: n/a

Default Can't delete SQL svr Agent jobs - 09-22-2008 , 02:56 PM






I am running MS SQL 2000. There are some agent jobs that I can not delete -
Error 14274: Cannot add, update or delete a job that originated from an MSX
server. How do I delete these jobs?
Tom

Reply With Quote
  #2  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM






Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #3  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #4  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #5  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #6  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #7  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #8  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #9  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
  #10  
Old   
Russell Fields
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-22-2008 , 03:36 PM



Tom,

Did the jobs really originate from an MSX server? If so, then you should
read:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Or was msdb restored from another server? (This might have happened, for
example, in creating a new server and restoring all of the databases from
the old server.) If the latter case, then what you should do is:

SELECT job_id, originating_server, name
FROM msdb.dbo.sysjobs

Is the originating_server column all naming some other, non-MSX, server? If
so, then simply:

UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServer'
WHERE originating_server = 'OldServer'

Of course, you need to have enough rights to run this script but that should
set the names correctly. In order to work with these jobs through SQL
Agent, I believe that you have to stop then restart SQL Agent in order to
refresh its cache.

RLF


"Tom Parke" <Tom Parke (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am running MS SQL 2000. There are some agent jobs that I can not
delete -
Error 14274: Cannot add, update or delete a job that originated from an
MSX
server. How do I delete these jobs?
Tom



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.