I have restore various dbs from one server to another server, this to includ
e
the msdb, model and master dbs.  I wanted to stop the jobs from run on my ne
w
server, and rename the originating_server name using script below:

use msdb

UPDATE    sysjobs
SET              originating_server = N'paadrsql2k01', enabled = 0
WHERE     (originating_server = N'paahousql2k01')

go


The server name got changed, and wanted to disable all jobs.  The status has
changed but jobs are still running.  Is there something that Im missing?

--
thx
jrod

[ Post a follow-up to this message ]

Sorry wrong place.

"jrod" wrote:

> I have restore various dbs from one server to another server, this to incl
ude
> the msdb, model and master dbs.  I wanted to stop the jobs from run on my 
new
> server, and rename the originating_server name using script below:
>
> use msdb
>
> UPDATE    sysjobs
> SET              originating_server = N'paadrsql2k01', enabled = 0
> WHERE     (originating_server = N'paahousql2k01')
>
> go
>
>
> The server name got changed, and wanted to disable all jobs.  The status h
as
> changed but jobs are still running.  Is there something that Im missing?
>
> --
> thx
> jrod

[ Post a follow-up to this message ]