How can I run a job from another server using a stored procedure?
- server 1 : db1
- server 2 : db2
- username : testssis
- password : testssispass
- sqljob found in db2: job1
Here is the part im lost with how can I make this work?
xp_cmdshell + osql command -U: -P: + sp_startjob