Tuesday, February 14, 2012

Delete Leftover SQL Jobs

Hi,
We have a SQL server that we moved from one physical server to another.
After the move we found that there are some SQL job in there that we no
longer need. Since they were created on the old server, Server IDs have now
changes and we can no longer delete them. Does anyone know how to delete
these jobs?
Thank you.The easy (but unsupported way) is to change the name of the server in msdb.d
bo.sysjobs:
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dragon" <baadil_nospam@.hotmail.com> wrote in message news:OBx4TKO$FHA.2812@.TK2MSFTNGP09.phx
.gbl...
> Hi,
> We have a SQL server that we moved from one physical server to another. Af
ter the move we found
> that there are some SQL job in there that we no longer need. Since they we
re created on the old
> server, Server IDs have now changes and we can no longer delete them. Does
anyone know how to
> delete these jobs?
> Thank you.
>|||Thank you Tibor. Excellent information. :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23A7LaxW$FHA.3804@.TK2MSFTNGP14.phx.gbl...
> The easy (but unsupported way) is to change the name of the server in
> msdb.dbo.sysjobs:
> http://www.karaszi.com/SQLServer/in...server_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dragon" <baadil_nospam@.hotmail.com> wrote in message
> news:OBx4TKO$FHA.2812@.TK2MSFTNGP09.phx.gbl...
>

No comments:

Post a Comment