Remote SQL Job

I have a job created on my local server and I would like to add a final step
that executes a job on a remote server. The remote server already has the
job set up on it, I just need a way to trigger it. Any ideas?
Thanks,
nivekEXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
"nivek" wrote:

> I have a job created on my local server and I would like to add a final st
ep
> that executes a job on a remote server. The remote server already has the
> job set up on it, I just need a way to trigger it. Any ideas?
> Thanks,
> nivek
>
>|||Thank you, that did the trick
nivek
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:1D6219E6-4061-4A1B-8268-477B76E56E3D@.microsoft.com...[vbcol=seagreen]
> EXEC ('EXEC remoteserver.msdb.dbo.sp_start_job ''job name''')
>
> "nivek" wrote:
>