dbTalk Databases Forums  

Can't delete SQL svr Agent jobs

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools 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
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM





Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #12  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM





Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #13  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM


Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #14  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM


Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #15  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM


Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #16  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM


Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #17  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM


Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #18  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM


Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
  #19  
Old   
Lee
 
Posts: n/a

Default Re: Can't delete SQL svr Agent jobs - 09-25-2008 , 06:58 PM


Tom,

Another way this can happen is if you rename a server. The solution is
still the as already shown by Russell.

Lee

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote

Quote:
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 in message
news:ADEA14D8-1BBE-4CD9-82F7-A2D5AD865C47 (AT) microsoft (DOT) com...
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
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top