|
|
||||||
|
#1
06-13-05, 09:43 PM
|
|
|
|
|
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? |
|
|
|
#2
06-13-05, 10:27 PM
|
|
|
|
|
Hi,
Can you stop and start SQL Agent service and see? Thanks Hari SQL Server MVP "jrod" <jrod> wrote in message news:a3cf [..] |
|
#3
06-14-05, 06:49 PM
|
|
|
|
|
Thx that did it.
"Hari Prasad" wrote: [..] |
|
|
| Similar Threads | |
| schedule jobs with ruby are there any tools to schedule jobs with ruby in xp. i dont want to use the windows scheduled jobs as i am having issue with it. |
|
| SSIS and Schedule Jobs We recently upgrade from SQL 2000 to 2005 and everything works great. But I have a problem which I know due of lack of knowledge. When I create a SSIS package with "SQL... |
|
| Multiple jobs on one schedule Hi I am wondering if it's possible to run multiple backup jobs from one shedule in SQL Server 2000, so all backups are triggered simultaneously at a given time. Having... |
|
| DTS/Schedule Jobs monitoring Is there a way to monitor all scheduled DTS jobs and restart the jobs automatically when it faillS. If the job continues failing after being restarted for several times then... |
|
| schedule jobs How can i create a stored procedure that runs a sql schedule or update the date and time for a schedule job. |
|
|
All times are GMT. The time now is 11:12 AM. | Privacy Policy
|
Change Schedule jobs