Executing a Windows schedule job task on a remote machine

Question

Executing a Windows schedule job task on a remote machine

mgraulich

Ten Centuries

Points: 1294
More actions
December 6, 2006 at 3:27 pm

#62392

Is there a way to create a schdeule job task within sql server that when executed will execute a remote schedule job task on another server? These are windows 2000 machines.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

Well, if you are using DTS, you can create an 'Execute Package' task on one server that will execute a DTS package on another server. What is it that your job on the remote server will be doing?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

MohammedU SSCoach Points: 19644 More actions · Answer 2

If want to execute SQL job on the remote server...

As John mentioned you can use DTS package using Execute Package task OR execute sql task in combination with XP_CMDSHELL..

OR

You can create the linked server on the source to dest. server and use servername.msdb..sp_start_job procedure too..

You can use Master/Target functionality..

MohammedU
Microsoft SQL Server MVP

Chris Dearden SSC Rookie Points: 35 More actions · Answer 3

you could call JT.exe ( resource kit tool ) using xp_cmdshell

http://www.jsifaq.com/SF/Tips/Tip.aspx?id=2621