Andy Phillips wrote:
> I am able to disable a job by using the follwing command:
> msdb..sp_update_job @job_name = 'Copy Logs',@enabled =0
>
> How can I disable a job running on a remote server from my local
> server. I need to do this because the remote server can go out of
> sync from my process and I want to place jobs on hold on the remote
> server based on activity on the local server

"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:e%23e70YtyEHA.3996@TK2MSFTNGP10.phx.gbl...
> Andy Phillips wrote:
> > I am able to disable a job by using the follwing command:
> > msdb..sp_update_job @job_name = 'Copy Logs',@enabled =0
> >
> > How can I disable a job running on a remote server from my local
> > server. I need to do this because the remote server can go out of
> > sync from my process and I want to place jobs on hold on the remote
> > server based on activity on the local server
>
> Try fully-qualifying the call [server].[db].[owner].[object]
>
> you may need to set up the server you want to access as a linked server
> using sp_addlinkedserver.
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>