February 28, 2017 at 9:56 am
Hello,
Need everyone's help, first in understanding, then to see if it works, maybe i am not understanding what my colleague is asking or concerned.
Little background, we have 3 sql server 2008 r2 clusters, they all are intertwined by using linked to each other, running queries and such from server to server (1 is active passive, 2 are active active, dont ask me why.... i didn't set this up 🙁 )
So i tested the link between sql server 2008 r2 to sql server 2016 (they are both enterprise), and it worked, i was able to call a store procedure from 2008 to 2016, and vise versa no problem. But my colleague was concerned with 2 things that maybe someone can shed light on:
1. she was concerned are we able to call and run a job from sql server 2008 to run a sql job on 2016, which the 2016 job has a stored procedure?
2. (this is the reaaaally confusing one), she said she doesn't use link server to make the call from a remote sql server, but able to run a stored procedure, by using the full unc path... is that even possible? or any thoughts as to what she might be asking or concerned about?
Big thanks to you all
February 28, 2017 at 11:02 am
Siten0308 - Tuesday, February 28, 2017 9:56 AMHello,Need everyone's help, first in understanding, then to see if it works, maybe i am not understanding what my colleague is asking or concerned.
Little background, we have 3 sql server 2008 r2 clusters, they all are intertwined by using linked to each other, running queries and such from server to server (1 is active passive, 2 are active active, dont ask me why.... i didn't set this up 🙁 )
So i tested the link between sql server 2008 r2 to sql server 2016 (they are both enterprise), and it worked, i was able to call a store procedure from 2008 to 2016, and vise versa no problem. But my colleague was concerned with 2 things that maybe someone can shed light on:
1. she was concerned are we able to call and run a job from sql server 2008 to run a sql job on 2016, which the 2016 job has a stored procedure?
2. (this is the reaaaally confusing one), she said she doesn't use link server to make the call from a remote sql server, but able to run a stored procedure, by using the full unc path... is that even possible? or any thoughts as to what she might be asking or concerned about?Big thanks to you all
1. Yes - getting the security right between all of the pieces will need some work (permissions for the linked server login on the remote server) but you'd use: EXEC LinkedServer.msdb.dbo.sp_start_job @job_name='YourJobOnLinkedServer'
2. I have no idea what that means either. There is no such thing as running a remote stored procedure by using the unc path. Some guesses are that she is calling a batch file that executes the stored proc that's on the other server or maybe the batch file is on some other server and calls the batch file using unc path. You can execute a job using sqlcmd and using that you can specify the SQL Server instance. Something along those lines would be my first guess. The whole "execute a stored procedure by using the full unc path" statement I don't get. Could you have her show you what she is talking about or ask her what unc path and then you may find what she is executing yourself.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply