'Error 14274' - Cannot add, update, or delete a job (or its steps or schedules) that ori

http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
I followed the tip above but it didn't work. anyone know of other workaround
?
I restore a copy of my Production DB on a TestDB, the scheduled jobs get
copied over as well. Cannot removed these job frm the Test DB because of
error 14274.
I logon the Test DB on workgroup, rename to original server name (on
workgroup because the Production still exist on the network), tried to
delete the jobs, SQL doesn't allow also. At the moment, I stopped the SQL
Agent Service to prevent the jobs frm running.
How to remove the jobs in the Test DB for good ?Don't bother with the rename stuff. Simply update the originating_server
column to reflect the new server name.
Have a look at http://sqldev.net/download/sqlagent/sp_sqlagent_rename.sql
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:%23GEUVi%23bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
>
> I followed the tip above but it didn't work. anyone know of other
workaround
> ?
> I restore a copy of my Production DB on a TestDB, the scheduled jobs get
> copied over as well. Cannot removed these job frm the Test DB because of
> error 14274.
> I logon the Test DB on workgroup, rename to original server name (on
> workgroup because the Production still exist on the network), tried to
> delete the jobs, SQL doesn't allow also. At the moment, I stopped the SQL
> Agent Service to prevent the jobs frm running.
> How to remove the jobs in the Test DB for good ?
>
>