May 4, 2009 at 7:34 am
Is it possible to set up a target server with a script rather than manually doing this from SQL Server agent?
Does anyone know what system tables are involved?
Thanks in advance.
May 4, 2009 at 11:11 am
are you talking about server event forwarding in sql agent?
set it up how you want in ssms on one of your non-configured servers, then (instead of hitting OK) press CTRL-SHIFT-N
it will create the script for you in a new window.
May 5, 2009 at 1:05 am
Hi, thanks for the reply but it's the making a server into a target server and then selecting the master server rather than the event forwarding, I tried your suggestion as the screen doesn't have a script button but it didn't do anything when I pressed CTRL+SHIFT+N.
May 6, 2009 at 8:15 am
I found the answer to this and it's to use sp_msx_enlist on the server you want to become the target.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy