Mark Forums Read

Can't delete SQL svr Agent jobs

Go Back

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

Reply

Page 1 of 2

1

#1

Old

Tom Parke

Posts: n/a

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

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

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

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

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

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

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

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

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

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

Page 1 of 2

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded 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.