15 Dec 2005
multiserver jobs exercise
Exercise
- Have a second instance of SQL Server running, either by:
- installing a second instance of SQL Server
- starting up a second Virtual PC
If using Virtual PC’s, check that you have network connectivity between both VPC’s:
- ipconfig
- ping
Ensure that both instances of SQL are using Mixed Mode Authentication
Using Tools, Wizards, Management, Make Master Server Wizard, setup Multiserver Jobs. Notice how an account called MSXOperator is created on both instances
Create a simple job on the Master, and get it to run on the Secondary
Hints
- remember to regularly refresh your display in Enterprise Manager, especially the Jobs node
- the job may take some minutes to copy. Be patient; if taking too long restart both agents
- check your setup by running this select statement on both instances:
SELECT * FROM msdb..systargetserverscomments powered by Disqus