Cannot Delete Job

I used the DTS transfer Jobs to copy a couple of jobs from one server to
another, I now aant to delete those jobs on the target server but I get an
error saying
"Error14274" Cannot add, update, or delete a job (or its steps or
schedule) that originated from an MSX server"
How can I delete these jobs I urgently need to get rid of these....
Thanks for your help,
BrianYou are using an MSX and TSX server, which means that the job you have on
your server was targetted from a master server.
The targetted client can not delete the job, it needs to be done on the
master server.
Check books online on master server jobs
To defect a target server from a master server
1.. Expand a server group, and then expand a server configured as a target
server.
2.. Expand Management.
3.. Right-click SQL Server Agent, point to Multi Server Administration,
and then click Defect from MSX.
4.. Click Yes to confirm that you want to defect this target server from a
master server.
--
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> I used the DTS transfer Jobs to copy a couple of jobs from one server to
> another, I now aant to delete those jobs on the target server but I get
an
> error saying
> "Error14274" Cannot add, update, or delete a job (or its steps or
> schedule) that originated from an MSX server"
> How can I delete these jobs I urgently need to get rid of these....
> Thanks for your help,
> Brian
>|||Dandy,
Thank you very much for your response, however, I am not using an MSX and
TXS server, at least not knowingly. When I right click Server Agent, I only
get the options to make the server a Master or a Target, is there anyway
that I can edit a system table to remove these?
The original server that the jobs came from will be going away today......
Thanks again,
Brian
"Dandy Weyn" <mct@.dandyman_nospam.net> wrote in message
news:40096d0e$0$773$ba620e4c@.news.skynet.be...
> You are using an MSX and TSX server, which means that the job you have on
> your server was targetted from a master server.
> The targetted client can not delete the job, it needs to be done on the
> master server.
> Check books online on master server jobs
> To defect a target server from a master server
> 1.. Expand a server group, and then expand a server configured as a
target
> server.
>
> 2.. Expand Management.
>
> 3.. Right-click SQL Server Agent, point to Multi Server Administration,
> and then click Defect from MSX.
>
> 4.. Click Yes to confirm that you want to defect this target server from
a
> master server.
> --
> Regards,
> Dandy Weyn
> MCSE, MCSA, MCDBA, MCT
> www.dandyman.net
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > I used the DTS transfer Jobs to copy a couple of jobs from one server to
> > another, I now aant to delete those jobs on the target server but I get
> an
> > error saying
> >
> > "Error14274" Cannot add, update, or delete a job (or its steps or
> > schedule) that originated from an MSX server"
> >
> > How can I delete these jobs I urgently need to get rid of these....
> >
> > Thanks for your help,
> >
> > Brian
> >
> >
>