September 27, 2005 at 2:19 pm
There is job from the master Server which I want to monitor or completely stop .The schedule has been changed on the master server and the job keeps on running on the target with the old schedule.
Is there something I am missing here
Thanks
Mike
September 30, 2005 at 8:00 am
This was removed by the editor as SPAM
October 1, 2005 at 4:04 am
On your MSX server have you tried 'Manage Target Servers' have you tried to 'Post Instructions' from either tab ? Also, have you tried a stop and restart ot the SQL Agent on each machine ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 3, 2005 at 12:47 pm
The schedule has been changed on the master server .Started/restarted the agent on both servers and even deleted the job entirely on the master server but it still runs on the target server.
Not sure what I am missing and would appreciate any input
Mike
October 3, 2005 at 1:40 pm
Is the JOB still executing ? If it is then kill the spid. If it does not 'die' you may have to resort to a /stop/start of SQL Server. If things still persist after a stop/start of SQL Server then you may have to manually delete the JOB from the system tables. Below is a good link on the system tables to brush up on:
http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply