Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
azar1818
Starting Member
1 Post |
 Posted - 2011-12-02 : 10:23:20
|
| Is there a way to run a job from a machine on the LAN without remoting in?ThanksMike |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-02 : 10:25:14
|
| yep...its possible if your machine is in same domain and its a sql job in machine to which you've a valid login. you can connect to server installed in machine from sql management studio installed in your machine and go to sql server agent to right click and execute the job in other machine.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-12-02 : 10:27:00
|
| Maybe, but probably not easily.Depends on what access you have and how many loops you are willing to jump through.You can maybe create a task on he remote system and run it.Another option is to have sql server on the remote machine (express) and do a remote call to xp_cmdshell to run a task.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Remote Job Task