|
Home > Archive > FrontPage Server Extensions for Windows > June 2005 > change schedule
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have restore various dbs from one server to another server, this to include
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 has
changed but jobs are still running. Is there something that Im missing?
--
thx
jrod
| |
|
| Sorry wrong place.
"jrod" wrote:
> I have restore various dbs from one server to another server, this to include
> 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 has
> changed but jobs are still running. Is there something that Im missing?
>
> --
> thx
> jrod
|
|
|
|
|