We have something like this.

We have an extract on server1 then a copy move to server2. then server1
starts the job on server2. Server2 then processes the file.

The last step in the job is as follows.. You'll have to set up
linked/remote server.


EXEC server2.msdb.dbo.sp_start_job @job_name = 'server2 job'

Hope this helps.


Peter L. Miller
Sr. Database Administrator
Educate, Inc.
phone: 410-843-6019
peter.[Email address protected]

-----Original Message-----
From: Stuart Davies
[mailto:mssqldba-ezmlmshield-x32377735.[Email address protected]
Sent: Thursday, August 18, 2005 9:49 AM
To: LazyDBA Discussion
Subject: starting jobs

I have two servers one only has Analysis Manager installed as also acts
as a FTP server (server1). The other is a SQL 2000 box with out Analysis
Manager (server2). I have data being ftp'd onto server1 from server3. When
server3 has sent the last file successfully, it runs a batch file to zip
up the data. I then have a job on server2 that ftps the zip file at
specific time of the day. I have tried to amend the batch file that zip
the data to start off the job via osql, which fails as osql isn't
installed on server1.
Has any one any ideas on how I can start the job on server2?
Thanks in advance for any suggestions
Stuart

**************************************************************************
*********
The contents of this email are confidential to the intended recipient.
It may not be disclosed to or used by anyone other than the addressee, nor
may it be copied in any way. If received in error, please contact the
company on 01793-715380, then delete it from your system. Please note
neither the company nor the sender accepts any responsibility for viruses
and it is your responsibility to scan attachments (if any) for viruses.
No contract may be concluded on behalf of the company by means of email
communications.

www.boxclever.co.uk
**************************************************************************
*********


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page