Re: Running job or DTS package on remote/other server of cluster

From: Andras Jakus (AndrasJakus_at_discussions.microsoft.com)
Date: 09/11/04 

Date: Sat, 11 Sep 2004 08:11:08 -0700

Hi

Another way:

Create linked server to srvB on srvA
Create stored procedure on srvB sp_myDTS with the following commad:

Exec xp_cmdshell 'DTSRUN /SSRVB\INSTB /E /NTest_DTS'

or with the following:

sp_start_job ''

create T-SQL job step on srvA:

execute [srvB].[MyDB].[dbo].[sp_myDTS]

Andras Jakus MCDBA

"dcsi" wrote:

> Thanks for the input, but...Still runs on SrvA. I can make the
> connection to SrvB and the Start method for the Job object runs
> successfully - but it runs on SrvA, where it is invoked.
>
> Any other thoughts out there???
>
>
>
> Andras Jakus <AndrasJakus@discussions.microsoft.com> wrote in message news:<AC70BE63-FE5D-4B79-A8C3-FC7EE760C05E@microsoft.com>...
> > HI
> >
> >
> > Use SQL-DMO (VB Script in ActiveX task) for job which executine second job
> > (run dts package) on srvB:
> >
> > Set conServer = CreateObject("SQLDMO.SQLServer")
> > conServer.LoginSecure = True
> > conServer.Connect "srvB"
> >
> > and use the job object: start method
> >
> > Andras Jakus
> >
> > "dcsi" wrote:
> >
> > > We have 2 clustered servers running MS Windows Server 2003 SP3a, SrvA
> > > & SrvB.
> > > A DTS package is defined on SrvB. A job runs on SrvA that needs to
> > > execute the package on SrvB when it completes. The package gets
> > > executed, but always on the server from which is was called,
> > > regardless of how it was called.
> > >
> > > We've tried setting up a job on SrvB that will execute the package and
> > > then using sp_start_job from SrvA - Still runs the package on SrvA.
> > >
> > > Also tried using an isql command on SrvA as follows:
> > > isql -SSRVB\INSTB -dmaster -E -Q"Exec xp_cmdshell
> > > 'DTSRUN /SSRVB\INSTB /E /NTest_DTS'"
> > > - Still runs on SrvA.
> > >
> > > Is there something about the cluster, with SrvA being the "master"
> > > that everything runs there regardless of command parameter
> > > specifications?
> > >
> > > It does not seem to be a security issue, as the job & package are
> > > found and run, just not from where they need to be run.
> > >
> > > What else can I try to get the package to actually run on the "remote"
> > > server?
> > >
>

Relevant Pages

  • Re: Running job or DTS package on remote/other server of cluster
    ... Thanks for the input, but...Still runs on SrvA. ... connection to SrvB and the Start method for the Job object runs ... >> A DTS package is defined on SrvB. ... >> execute the package on SrvB when it completes. ...
    (microsoft.public.sqlserver.server)
  • Running job or DTS package on remote/other server of cluster
    ... We have 2 clustered servers running MS Windows Server 2003 SP3a, SrvA ... A DTS package is defined on SrvB. ...
    (microsoft.public.sqlserver.server)
  • Tried that too...
    ... still ends up running on SrvA. ... > Create linked server to srvB on srvA ... >> connection to SrvB and the Start method for the Job object runs ...
    (microsoft.public.sqlserver.server)