Drop Target Server When MSX Server Gone

Due to disk failure and lack of current backups ( I just started here) we
were forced to restore a copy of msdb from over a year ago.
(I had to put the database back together again like Humpty Dumpty)
My problem is that there are several jobs that were pushed from an MSX
server that no longer exists.
I can't delete them - it tells me to go to the MSX server.
Any suggestions?HI
Defect target server from master.
Enlist again, and assign jobs to target.
Or
Delete jobssteps and jobs from msdb.dbo.sysjobsteps,
msdb.dbo.sysjobschedules and msdb.dbo.sysjobs.
Andras Jakus MCDBA
"Amanda" wrote:

> Due to disk failure and lack of current backups ( I just started here) we
> were forced to restore a copy of msdb from over a year ago.
> (I had to put the database back together again like Humpty Dumpty)
> My problem is that there are several jobs that were pushed from an MSX
> server that no longer exists.
> I can't delete them - it tells me to go to the MSX server.
> Any suggestions?|||You should be able to use the information in step 3 at
http://www.karaszi.com/SQLServer/in...erver_name.asp.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Amanda" <Amanda@.discussions.microsoft.com> wrote in message
news:FF74683A-DAFB-4255-85A9-00DB3FA850D8@.microsoft.com...
> Due to disk failure and lack of current backups ( I just started here) we
> were forced to restore a copy of msdb from over a year ago.
> (I had to put the database back together again like Humpty Dumpty)
> My problem is that there are several jobs that were pushed from an MSX
> server that no longer exists.
> I can't delete them - it tells me to go to the MSX server.
> Any suggestions?|||WAY COOL!
This worked. The other solution won't work because it won't let you change
anything on the target server - only on the master, which doesn't exist.
This worked wonderfully, though. Thanks.
"Tibor Karaszi" wrote:

> You should be able to use the information in step 3 at
> http://www.karaszi.com/SQLServer/in...erver_name.asp.
>