Deleting jobs when MX Server not available.

Hi All
I have some SQL jobs which I can't delete because they
were originally setup from an MX (master) server. That MX
server is no longer available so how do I delete the jobs?
I assume I'm going to have to delete the entries from the
MSDB datase, but what tables do I need to take the rows
out from?
ThanksIT is easier to just change the originating_server column in sysjobs to your
machine name. This "makes" the jobs normal non-msx jobs. You can do this
with a simple update statement. Note that it is not supported to modify the
system tables directly, so do at your own risk and make sure you have a
backup first.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:16c801c3a89e$57848e70$a601280a@.phx.gbl...
> Hi All
> I have some SQL jobs which I can't delete because they
> were originally setup from an MX (master) server. That MX
> server is no longer available so how do I delete the jobs?
> I assume I'm going to have to delete the entries from the
> MSDB datase, but what tables do I need to take the rows
> out from?
> Thanks
>|||Thanks Tibor.
I tried it out and it works like a gem.
Thanks again
-Jono