Sunday, March 11, 2012

Calling a job on another server...How to

Hello, all. Was wondering if it is possible to execute a scheduled job
located on another server? For example, on Server A, I have a few scheduled
DTS jobs I want run by being executed from a DTS job on Server B.
As always,
Thnx!
RozPossibly through a linked server from a TSQL task/jobstep:
EXEC srvname.msdb.dbo.sp_start_job
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:041038EE-0A29-48B7-97A5-6DD31B5A9DB7@.microsoft.com...
> Hello, all. Was wondering if it is possible to execute a scheduled job
> located on another server? For example, on Server A, I have a few schedule
d
> DTS jobs I want run by being executed from a DTS job on Server B.
> As always,
> Thnx!
> Roz
>|||Sounds like it'll work. I'll give it a shot, and report back.
Thanks!
"Tibor Karaszi" wrote:

> Possibly through a linked server from a TSQL task/jobstep:
> EXEC srvname.msdb.dbo.sp_start_job
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Roz" <Roz@.discussions.microsoft.com> wrote in message
> news:041038EE-0A29-48B7-97A5-6DD31B5A9DB7@.microsoft.com...
>

No comments:

Post a Comment