Can't delete job

When attempt to delete a job, the following error is
encountered:
Cannot add, update, or delete a job (or its steps or
schedules) that originated from an MSX server.
How would you reslove this?
Thanks,
BenDo you have master-target server configuration setup? If not, did you
recently rename your SQL Server?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ben" <bluebells88@.yahoo.com> wrote in message
news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
When attempt to delete a job, the following error is
encountered:
Cannot add, update, or delete a job (or its steps or
schedules) that originated from an MSX server.
How would you reslove this?
Thanks,
Ben|||Sorry, what is 'master-target server configuration
setup'?
The machine joined a domain group after the job is
created.
Thanks,
Ben
>--Original Message--
>Do you have master-target server configuration setup? If
not, did you
>recently rename your SQL Server?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Ben" <bluebells88@.yahoo.com> wrote in message
>news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
>When attempt to delete a job, the following error is
>encountered:
>Cannot add, update, or delete a job (or its steps or
>schedules) that originated from an MSX server.
>How would you reslove this?
>Thanks,
>Ben
>
>.
>|||You probably have incorrect machine name in msdb..sysjobs. The old machine
name is still in msdb..sysjobs. Since you changed the machine name, SQLAgent
now thinks that this job is owned by a master server. You can change
the machine names for all jobs with below SQL Statement. Warning: Hacking
system tables is not supported and should be done with care (below should be
rather safe, though).
DECLARE @.srv sysname
SET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
NOTE:
If this is a target server (you have jobs sent from a master server), you
have to exclude them, so you don't transfer those jobs into local jobs:
WHERE originating_server = 'oldservname'
If you want to do this the supported way, see below KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ben" <bluebells88@.yahoo.com> wrote in message
news:44ba01c3fe7b$b69c3970$a101280a@.phx.gbl...
> Sorry, what is 'master-target server configuration
> setup'?
> The machine joined a domain group after the job is
> created.
> Thanks,
> Ben
> >--Original Message--
> >Do you have master-target server configuration setup? If
> not, did you
> >recently rename your SQL Server?
> >--
> >HTH,
> >Vyas, MVP (SQL Server)
> >http://vyaskn.tripod.com/
> >Is .NET important for a database professional?
> >http://vyaskn.tripod.com/poll.htm
> >
> >
> >"Ben" <bluebells88@.yahoo.com> wrote in message
> >news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
> >When attempt to delete a job, the following error is
> >encountered:
> >
> >Cannot add, update, or delete a job (or its steps or
> >schedules) that originated from an MSX server.
> >
> >How would you reslove this?
> >
> >Thanks,
> >Ben
> >
> >
> >.
> >|||Thanks all for the helps.
Ben
>--Original Message--
>You probably have incorrect machine name in
msdb..sysjobs. The old machine
>name is still in msdb..sysjobs. Since you changed the
machine name, SQLAgent
>now thinks that this job is owned by a master server.
You can change
>the machine names for all jobs with below SQL Statement.
Warning: Hacking
>system tables is not supported and should be done with
care (below should be
>rather safe, though).
>DECLARE @.srv sysname
>SET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
>UPDATE sysjobs SET originating_server = @.srv
>
>NOTE:
>If this is a target server (you have jobs sent from a
master server), you
>have to exclude them, so you don't transfer those jobs
into local jobs:
>WHERE originating_server = 'oldservname'
>
>If you want to do this the supported way, see below KB
article
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;281642
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Ben" <bluebells88@.yahoo.com> wrote in message
>news:44ba01c3fe7b$b69c3970$a101280a@.phx.gbl...
>> Sorry, what is 'master-target server configuration
>> setup'?
>> The machine joined a domain group after the job is
>> created.
>> Thanks,
>> Ben
>> >--Original Message--
>> >Do you have master-target server configuration setup?
If
>> not, did you
>> >recently rename your SQL Server?
>> >--
>> >HTH,
>> >Vyas, MVP (SQL Server)
>> >http://vyaskn.tripod.com/
>> >Is .NET important for a database professional?
>> >http://vyaskn.tripod.com/poll.htm
>> >
>> >
>> >"Ben" <bluebells88@.yahoo.com> wrote in message
>> >news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
>> >When attempt to delete a job, the following error is
>> >encountered:
>> >
>> >Cannot add, update, or delete a job (or its steps or
>> >schedules) that originated from an MSX server.
>> >
>> >How would you reslove this?
>> >
>> >Thanks,
>> >Ben
>> >
>> >
>> >.
>> >
>
>.
>