Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql server query

Status
Not open for further replies.
PleaseWork

PleaseWork

Technical User
Joined
Jan 7, 2010
Messages
1
Location
ZA
I am trying to schedule a job using the SQL Executive, that must execute a command on a different machine (not another SQL server, although it could be). In this case the machine I want to run the command on is an NT4 machine (but the principle needs to apply to any machine)
Must the machine be on the same domain
 
Sort by date Sort by votes
You can use at to launch commands on remote machines.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question Question
Problem Date MS SQL Server
Replies
0
Views
776
petart
petart
ItHurtsWhenIThink
  • Locked
  • Question Question
Using Distinct and count in same query???
Replies
4
Views
840
gk53
gk53
smsmail
  • Locked
  • Question Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
1K
markjoseph1232
markjoseph1232
botatun
  • Locked
  • Question Question
the linked server insert data to csv in wrong order
Replies
0
Views
623
botatun
botatun
betachristopher
  • Locked
  • Question Question
Use IF/ELSE in Query
Replies
3
Views
786
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top